테이블스페이스 용량구하기...

--데이터파일 사용량 구하기
select C.C_T "GLOBAL_NAME", a.A_T "ALLOC", A.A_T-B.B_T "USED",B.B_T "FREE"
from ( select round(sum(bytes/1024/1024),-1) AS A_T from dba_Data_files ) a,
( select round(sum(bytes/1024/1024),-1) AS B_T from dba_free_space ) b,
( select replace(GLOBAL_NAME,'.WORLD','') AS C_T from global_name ) c

SELECT b.file_name "FILE_NAME", -- DataFile Name
b.tablespace_name "TABLESPACE_NAME", -- TableSpace Name
b.bytes / 1024 "TOTAL SIZE(KB)", -- 총 Bytes
((b.bytes - sum(nvl(a.bytes,0)))) / 1024 "USED(KB)", -- 사용한 용량
(sum(nvl(a.bytes,0))) / 1024 "FREE SIZE(KB)", -- 남은 용량
(sum(nvl(a.bytes,0)) / (b.bytes)) * 100 "FREE %" -- 남은 %
FROM DBA_FREE_SPACE a, DBA_DATA_FILES b
WHERE a.file_id(+) = b.file_id
GROUP BY b.tablespace_name, b.file_name, b.bytes
ORDER BY b.tablespace_name