Speicherverbraucher Top10 der Oracle-Objekte

SELECT *
  FROM (  SELECT *
            FROM dba_segments
        ORDER BY bytes DESC)
 WHERE ROWNUM <= 10

SELECT * FROM ( SELECT * FROM dba_segments ORDER BY bytes DESC) WHERE ROWNUM <= 10

SELECT *
  FROM (  SELECT l.owner,
                 l.table_name,
                 l.column_name,
                 l.segment_name,
                 l.tablespace_name,
                 l.index_name,
                 ROUND (s.bytes / 1024 / 1024) "SIZE IN MB"
            FROM dba_lobs l, dba_segments s
           WHERE     s.segment_type = 'LOBSEGMENT'
                 AND l.segment_name = s.segment_name
        ORDER BY s.bytes DESC)
 WHERE ROWNUM <= 10;

SELECT * FROM ( SELECT l.owner, l.table_name, l.column_name, l.segment_name, l.tablespace_name, l.index_name, ROUND (s.bytes / 1024 / 1024) "SIZE IN MB" FROM dba_lobs l, dba_segments s WHERE s.segment_type = 'LOBSEGMENT' AND l.segment_name = s.segment_name ORDER BY s.bytes DESC) WHERE ROWNUM <= 10;