DB 전체 용량 (전체, 사용중, 남은용량) 확인 쿼리

SELECT 'ALL_SPACE' AS TYPE , ROUND(SUM(BYTES)/1024/1024/1024,2) AS SPACE_GB FROM DBA_DATA_FILES UNION ALL
SELECT 'USED_SPACE' AS TYPE, ROUND(SUM(BYTES)/1024/1024/1024,2) AS USED_GB FROM DBA_SEGMENTS UNION ALL
SELECT 'FREE_SPACE' AS TYPE, ROUND(SUM(BYTES)/1024/1024/1024,2) AS FREE_GB FROM DBA_FREE_SPACE;

 

결과