SELECT bytes FROM dba_extents
  WHERE owner='SCOTT'
    AND segment_type='TABLE'
    AND segment_name='EMP';
