something like this --

select substr(segment_name,1,30), bytes from (select segment_name, bytes from dba_segments order by bytes desc) where rownum < 11


- Rajeev