テーブルスペースの使用状況確認方法

SELECT T.TABLESPACE_NAME,
TRUNC(T.BYTES/(1024*1024),0) TOTAL_M,
ROUND((T.BYTES - SUM(F.BYTES)) / (1024*1024),0) USED_M,
ROUND(SUM(F.BYTES) / (1024*1024),0) FREE_M,
ROUND((1-SUM(F.BYTES) / T.BYTES)*100,2) RATE
FROM SYS.DBA_FREE_SPACE F,
(SELECT TABLESPACE_NAME,
SUM(BYTES) BYTES
FROM SYS.DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) T
WHERE T.TABLESPACE_NAME = F.TABLESPACE_NAME(+)
GROUP BY T.TABLESPACE_NAME,
T.BYTES
;