오라클 데이터베이스이 테이블 스페이스별 사용량을 알아보자. > db

SELECT SUBSTRB(A.TABLESPACE_NAME, 1,16) as TABLESPACE,
       TO_CHAR((A.TOTAL/1024), '999,999,999,990') as "총량(M바이트)",
       TO_CHAR((B.FREE/1024),  '999,999,999,990') as "남은량(M바이트)",
       TO_CHAR((A.TOTAL-B.FREE)/1024,  '999,999,999,990') as "사용량(M바이트)",
       TO_CHAR(A.BLOCKS, '9,999,990') as "총블럭",
       TO_CHAR(C.BLOCKS,  '9,999,990') as "사용블럭",
       TO_CHAR(100*NVL(C.BLOCKS,0)/A.BLOCKS, '999.99') as "사용율%"
FROM (SELECT TABLESPACE_NAME,
             SUM(BYTES)  as TOTAL,
             SUM(BLOCKS) as BLOCKS
      FROM DBA_DATA_FILES
      GROUP BY TABLESPACE_NAME
     ) A,
     (SELECT TABLESPACE_NAME,
             SUM(BYTES) as FREE
      FROM DBA_FREE_SPACE
      GROUP BY TABLESPACE_NAME
     ) B,
     (SELECT TABLESPACE_NAME,
             SUM(BLOCKS) as BLOCKS
      FROM DBA_EXTENTS
      GROUP BY TABLESPACE_NAME
     ) C
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME(+)
      AND A.TABLESPACE_NAME = C.TABLESPACE_NAME(+)
ORDER BY A.TABLESPACE_NAME ;