Oracle Tablo Boyutları

SELECT A.OWNER,
A.TABLE_NAME,
NUM_ROWS,
TRUNC (b.size_G, 2) AS SIZE_G
FROM DBA_TABLES A,
(  SELECT owner, table_name, ROUND (SUM (bytes) / 1024 / 1024 / 1024) SIZE_G
  FROM (SELECT segment_name table_name, owner, bytes
  FROM dba_segments
WHERE segment_type IN ('TABLE',
'TABLE PARTITION',
'TABLE SUBPARTITION')
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 IN ('INDEX',
  'INDEX PARTITION',
  'INDEX SUBPARTITION')
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 IN ('LOBSEGMENT',
  'LOB PARTITION',
  'LOB SUBPARTITION')
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, owner
  ORDER BY SUM (bytes) DESC) b
WHERE     A.TABLE_NAME IN ('AUDIT_COUNTER',
'AUDIT_DETAILS',
'AUDIT_TRAIL',
'CI_INDEXES',
'CUBE_INSTANCE',
'CUBE_SCOPE',
'DLV_MESSAGE',
'DLV_SUBSCRIPTION',
'DOCUMENT_CI_REF',
'DOCUMENT_DLV_MSG_REF',
'HEADERS_PROPERTIES',
'WI_FAULT',
'WORK_ITEM',
'XML_DOCUMENT',
'COMPONENT_INSTANCE',
'COMPOSITE_INSTANCE',
'COMPOSITE_INSTANCE_ASSOC',
'COMPOSITE_INSTANCE_FAULT',
'COMPOSITE_SENSOR_VALUE',
'INSTANCE_PAYLOAD',
'REFERENCE_INSTANCE',
'REJECTED_MESSAGE',
'REJECTED_MSG_NATIVE_PAYLOAD',
'MEDIATOR_AUDIT_DOCUMENT',
'MEDIATOR_CASE_DETAIL',
'MEDIATOR_CASE_INSTANCE',
'MEDIATOR_DEFERRED_MESSAGE',
'MEDIATOR_INSTANCE',
'MEDIATOR_PAYLOAD')
AND A.OWNER = 'TTOTEST_SOAINFRA'
AND a.table_name = b.TABLE_name
AND A.OWNER=B.OWNER
ORDER BY TABLE_NAME