테이블 스페이스 용량 확인 쿼리

SELECT SUBSTR(a.tablespace_name,1,30) TABLESPACE , ROUND(SUM(a.total1) /1024/1024,1) "TotalMB" , ROUND(SUM(a.total1) /1024/1024,1)-ROUND(SUM(a.sum1)/1024/1024,1) "UsedMB" , ROUND(SUM(a.sum1) /1024/1024,1) "FreeMB" , ROUND((ROUND(SUM(a.total1)/1024/1024,1)-ROUND(SUM(a.sum1)/1024/1024,1))/ROUND(SUM(a.total1)/1024/1024,1)*100,2) "Used%" FROM (SELECT tablespace_name ,0 total1 ,SUM(bytes) sum1 ,MAX(bytes) MAXB ,COUNT(bytes) cnt FROM dba_free_space GROUP BY tablespace_name UNION SELECT tablespace_name ,SUM(bytes) total1 ,0,0,0 FROM dba_data_files GROUP BY tablespace_name ) a GROUP BY a.tablespace_name ORDER BY TABLESPACE;

발췌 : http://javafactory.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4-%ED%85%8C%EC%9D%B4%EB%B8%94%EC%8A%A4%ED%8E%98%EC%9D%B4%EC%8A%A4-%EC%9A%A9%EB%9F%89-%EC%A1%B0%ED%9A%8C-oracle-tablespace-%EC%9A%A9%EB%9F%89-%EC%A1%B0%ED%9A%8C