SQL QUERY TO FIND TOP SIZED TABLES OR SEGMENTS IN ORACLE
Use the query to find the top segments or tables in oracle database
select * from (
select segment_name,
owner,
bytes/1048576 MB
from dba_segments
where owner not in ('SYS','SYSTEM')
order by 3 desc)
where rownum < 6;