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>