
select segment_name, owner, blocks from dba_extents
 where tablespace_name = 
      (select object_name from dba_objects
       where object_type='TABLESPACE');



