Monday, March 19, 2012

How to find Large Objects in a Tablespace


select segment_name,segment_type,sum(bytes)/1024/1024 mb from dba_segments
where tablespace_name = 'APPS_TS_TX_DATA' having (sum(bytes)/1024/1024)>1024 group by segment_name,segment_type order by 3 desc;

No comments:

Post a Comment