[oracle]ORACLE DB 전체 용량 확인

ORACLE DB 전체 용량 확인

-- ★★★★★ ORACLE DB 전체 용량 확인 : DBA_DATA_FILES  ★★★★★

SELECT SUM(bytes) FROM DBA_DATA_FILES;
SELECT SUM(bytes)/1024/1024/1024||'GB' FROM DBA_DATA_FILES;

-- ★★★★★ ORACLE DB 전체 사용량 확인 : DBA_SEGMENTS  ★★★★★

SELECT SUM(bytes) FROM DBA_SEGMENTS;
SELECT SUM(bytes)/1024/1024/1024||'GB' FROM DBA_SEGMENTS;

-- ★★★★★ ORACLE DB 전체 여유량 확인 : DBA_FREE_SPACE  ★★★★★

SELECT SUM(bytes) FROM DBA_FREE_SPACE;
SELECT SUM(bytes)/1024/1024/1024||'GB' FROM DBA_FREE_SPACE;