오라클 DB 사용량 확인하는 쿼리

1. DB 전체 용량 확인
select sum(bytes) from dba_data_files;

select sum(bytes)/1024/1024/1024 ||'GB' from dba_data_files;    



2. DB 사용량 확인
select sum(bytes) from dba_segments;

select sum(bytes)/1024/1024/1024 ||'GB' from dba_segments;    



3. DB 여유량 확인
select sum(bytes) from dba_free_space;

select sum(bytes)/1024/1024/1024 ||'GB' from dba_free_space;