Wednesday, August 18, 2010

Space wise what are the top 10 objects

What are the top 10 consumers of space in a tablespace:


col owner for a7
col segment_name for a30
col MBytes for 9,999.99
select *
from (select owner, segment_name, sum(bytes)/1024/1024 MBytes
from dba_segments
where tablespace_name='SYSTEM'
group by owner, segment_name
order by 3 desc)
where rownum<11;

No comments: