select OWNER, t.segment_name, t.segment_type, sum(t.bytes /  /  / ) G

from dba_segments t

where t.owner = 'TPSC'

group by OWNER, t.segment_name, t.segment_type

order by G desc;