Format

column segment_name format a45;
select owner, segment_name, segment_type, round(bytes/1024/1024,1) meg
from dba_segments
where owner in ('STABS','STABS2')
order by owner, segment_type, meg desc
/