TableSpace 사용량 산출

SELECT
   A.TABLESPACE_NAME TableSpaceName,
   ROUND(A.BYTES / 1024 / 1024, 0) TotalMemory,
   ROUND(((A.BYTES - SUM(NVL(B.BYTES,0)))) / 1024 / 1024, 0) UsedMegaBytes,
   ROUND((SUM(NVL(B.BYTES,0))) / 1024 / 1024 ,0) FreeMegaBytes,
   ROUND((SUM(NVL(B.BYTES,0)) / (A.BYTES)) *100 ,0) FreePercent,
   A.FILE_NAME DataFile,
   SYSDATE CheckDate
FROM
   DBA_DATA_FILES A RIGHT OUTER JOIN DBA_FREE_SPACE B ON (A.FILE_ID = B.FILE_ID)
GROUP BY A.TABLESPACE_NAME, A.FILE_NAME, A.BYTES
ORDER BY A.TABLESPACE_NAME;