오라클 테이블용량산정(DBA)

SELECT A.SEGMENT_NAME,

              ROUND(SUM(A.BYTES)) "SIZE_B",

              A.SEGMENT_TYPE

FROM DBA_SEGMENTS A, 

            DBA_TABLES B

WHERE A.SEGMENT_NAME = B.TABLE_NAME

      AND A.SEGMENT_TYPE IN ('TABLE','TABLE PARTITION')

      AND A.OWNER = 'MOARABASE'

GROUP BY A.SEGMENT_NAME, A.SEGMENT_TYPE

ORDER BY 2 DESC;

 

SELECT A.SEGMENT_NAME,

              ROUND(SUM(A.BYTES)) "SIZE_B",

              A.SEGMENT_TYPE

FROM DBA_SEGMENTS A, 

            DBA_INDEXES B

WHERE A.SEGMENT_NAME = B.INDEX_NAME

      AND A.SEGMENT_TYPE IN ('INDEX','INDEX PARTITION')

      AND A.OWNER = 'MOARA03'

GROUP BY A.SEGMENT_NAME, A.SEGMENT_TYPE

ORDER BY 2 DESC;