Monday, 24 September 2012

Size oracle object in system schema

select owner,segment_name,segment_type ,bytes/(1024*1024) size_m from dba_segments where tablespace_name = 'SYSTEM' and bytes/(1024*1024) >1 order by size_m desc;

No comments:

Post a Comment