Show the ten largest objects in your database

select owner , segment_name , segment_type , mb from ( select owner , segment_name

,segment_type , bytes / 1024 / 1024 "Megabyte" from dba_segments order by bytes desc )

where rownum < 11