Combine DBA_SEGMENTS and DBA_FREE_SPACE : DBA_FREE_SPACE « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. 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>