Onesqltocalculatetheschema & amp; #39; stablecapacity

SELECTowner, table_name, TRUNC (SUM (bytes) (1024*1024) MBFROM (SELECTsegment_nametable_name, owner, region, I. owner, s. bytesFROMdba_indexesi, dba_segmentss

SELECT owner, table_name, TRUNC (SUM (bytes)/(1024*1024) MBFROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE segment_type = 'table' union all select I. table_name, I. owner, s. bytes FROM dba_indexes I, dba_segments s

SELECT owner,  table_name,  TRUNC(SUM(bytes)/(1024*1024)) MBFROM  (SELECT segment_name table_name,    owner,    bytes  FROM dba_segments  WHERE segment_type = 'TABLE'  UNION ALL  SELECT i.table_name,    i.owner,    s.bytes  FROM dba_indexes i,    dba_segments s  WHERE s.segment_name = i.index_name  AND s.owner          = i.owner  AND s.segment_type   = 'INDEX'  UNION ALL  SELECT l.table_name,    l.owner,    s.bytes  FROM dba_lobs l,    dba_segments s  WHERE s.segment_name = l.segment_name  AND s.owner          = l.owner  AND s.segment_type   = 'LOBSEGMENT'  UNION ALL  SELECT l.table_name,    l.owner,    s.bytes  FROM dba_lobs l,    dba_segments s  WHERE s.segment_name = l.index_name  AND s.owner          = l.owner  AND s.segment_type   = 'LOBINDEX'  )GROUP BY table_name,  ownerORDER BY SUM(bytes) DESC ;