SELECT segment_name table_name,
SUM(BYTES) /(1024 * 1024) table_size_meg
FROM user_extents
WHERE segment_type = 'TABLE' AND
segment_name = 'MY_TABLE'
GROUP BY segment_name
My Experiences with Oracle Database Administration...
SELECT segment_name table_name,
SUM(BYTES) /(1024 * 1024) table_size_meg
FROM user_extents
WHERE segment_type = 'TABLE' AND
segment_name = 'MY_TABLE'
GROUP BY segment_name
ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com
0 comments:
Post a Comment