Wednesday, November 13, 2013

script to list Top 10 big objects in oracle?

Col owner format a15
Col segment_name format a30
Col segment_type format a15
Col mb format 999,999,999
select  owner,segment_name,segment_type,mb
from(select owner,segment_name,segment_type,bytes / 1024 / 1024 "MB"
from dba_segments
order by bytes desc
)
where rownum < 11

No comments:

Post a Comment