ORACLE BIGGEST OBJECTS

Table

select Owner, Tablespace_name, Segment_name, Bytes / 1024 / 1024 || 'M' "Size"

  From Dba_segments 

 Where Segment_type = 'TABLE'

   Order by Bytes desc;

INDEX

select Owner, Tablespace_name, Segment_name, Bytes / 1024 / 1024 || 'M' "Size"

  From Dba_segments 

Where Segment_type = 'INDEX'

   Order by Bytes desc;

ALL

select Owner, Tablespace_name, Type, Segment_name, Bytes / 1024 / 1024 || 'M' "Size"

  From Dba_segments 

   Order by Bytes desc;