Oracle database real life problems and recommended solutions!
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