select owner, segment_type, sum(bytes)/1024/1024 "MB"
from dba_segments
group by owner, segment_type;