[Nelson Anchite]

Talvez esse SQL possa te ajudar.

select owner, tablespace_name, segment_name, bytes, extents, max_extents, initial_Extent
from dba_segments
where segment_type=’TABLE’
order by bytes