select extents, bytes
 from dba_segments
where owner='SCOTT'
  and segment_name='EMP'
  and segment_type='TABLE';
