프로그래밍/Database
DB 전체 용량 (전체, 사용중, 남은용량) 확인 쿼리
김민쏭
2020. 3. 25. 09:34
|
1
2
3
|
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;
|
cs |
결과
