테이블스페이스 남아 있는 공간 확인

SELECT d.tn,
       ROUND (total / 1000000) "TOTAL(MB)",
       ROUND (FREE / 1000000) "FREE(MB)",
       TO_CHAR (ROUND (free / total * 100, 1), '99.9') || '%' RATE
  FROM (  SELECT TABLESPACE_NAME TN, SUM (BYTES) TOTAL
            FROM DBA_DATA_FILES
        GROUP BY TABLESPACE_NAME) D,
       (  SELECT TABLESPACE_NAME TN, SUM (BYTES) FREE
            FROM DBA_FREE_SPACE
        GROUP BY TABLESPACE_NAME) F
 WHERE D.TN = F.TN;