select substr(segment_name,1,35), tablespace_name, sum(bytes/1024/1024) mb
       from dba_extents
       where tablespace_name = 'tablespace_name'
       group by segment_name, tablespace_name
       order by 1,2, 3