Wednesday, October 12, 2011

Script to Finde the size of the table


SQL> select segment_name, sum(bytes)/(1024*1024) as SIZE_IN_MB from dba_extents
     where segment_type = 'TABLE'
     and
     segment_name = 'MY_TABLE'
     group by segment_name;

No comments:

Post a Comment