Oracle - Tablespace

[ Oracle - Tablespace ]

☞ 테이블스페이스 총 크기, 사용량, 남은 공간 조회

SELECT a.tablespace_name, ROUND(SUM(a.total) / 1024/1024, 2)             "Totab(M)"      , ROUND((SUM(a.total) - SUM(NVL(b.free, 0))) / 1024/1024,2)         "Used(M)"      , ROUND((SUM(NVL(b.free, 0))) / 1024/1024, 2)                       "Free(ML)"      , ROUND((SUM(a.total) - SUM(NVL(b.free, 0)))/SUM(a.total) * 100, 2) "Used(%)" FROM (SELECT d.tablespace_name, d.file_id, SUM(d.bytes) total       FROM   dba_data_files d       GROUP  BY d.tablespace_name, d.file_id) a,      (SELECT f.file_id, SUM(f.bytes) free FROM dba_free_space f       GROUP  BY f.file_id) b WHERE a.file_id = b.file_id(+) GROUP BY a.tablespace_name;