Check DBA_SEGMENTS view:
select owner, segment_name, sum(bytes), sum(blocks) from dba_Segments where tablespace_name = 'yourtabelspace' group by owner, segment_name;
This will give you all the segments and their owners sharing slice of the specific tablespace.




Reply With Quote