table space 조회

SELECT A.TABLESPACE_NAME, TO_NUMBER(A.BYTES), SUM(B.BYTES), TO_NUMBER(A.BYTES) - SUM(B.BYTES) AS FREE_SPACE
FROM DBA_DATA_FILES A, DBA_FREE_SPACE B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME
GROUP BY A.TABLESPACE_NAME, A.BYTES