Oracle PL/SQL Tutorial/System Tables Data Dictionary/DBA FREE SPACE

Combine DBA_SEGMENTS and DBA_FREE_SPACE

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>
SQL>
SQL>
SQL>