오라클 테이블 용량 조회

http://www.hyochun.com/20

 

-- 테이블 용량 조회
SELECT
    SEGMENT_TYPE
    , SEGMENT_NAME
    , TABLESPACE_NAME
    , SUM(BYTES)
FROM DBA_SEGMENTS   
WHERE SEGMENT_TYPE IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION')
AND OWNER = '<owner>'
GROUP BY SEGMENT_TYPE
    , SEGMENT_NAME
    , TABLESPACE_NAME;