Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>