테이블스페이스 사용가능 공간확인

dba_data_files, dba_free_space 뷰 사용

select d.tn, round(total/1024/1024) total_mb,
round(free/1024/1024) free_mb,
to_char(round(free/total*100,1), '99.9')||'%' rate
from (select tablespace_name tn, sum(bytes) total
 from dba_data_files
 group by tablespace_name) d,
 (select tablespace_name tn, sum(bytes) free
 from dba_free_space
 group by tablespace_name) f
where d.tn=f.tn;