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:
Post a Comment