System Tables Data Dictionary Oracle PLSQL Tutorial

SQL>  select Owner, Segment_Name, Segment_Type
  2    from DBA_SEGMENTS
  3   where Next_Extent >
  4  (select SUM(Bytes) from DBA_FREE_SPACE
  5    where Tablespace_Name = DBA_SEGMENTS.Tablespace_Name);
SQL>