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

Combine DBA_SEGMENTS and DBA_FREE_SPACE

   <source lang="sql">

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></source>