Top Ten Sizes of Tables and Indexes in Oracle

Hi Guy's,

I found very nice scripts from 'DON BURLESON' website which gives the top ten sizes of Tables and Indexes.



SQL> select * from (select owner,segment_name,bytes/1024/1024 meg from dba_segments where segment_type='TABLE' order by bytes/1024/1024 desc) where rownum <= 10;


SQL> select * from (select owner,segment_name,bytes/1024/1024 meg from dba_segments where segment_type='INDEX' order by bytes/1024/1024 desc) where rownum <= 10;




Happy Reading...