오라클 테이블 스페이스 상태점검 쿼리

출처: http://isecurity.textcube.com/12

SELECT
  ts.status
 ,data.name
 ,ts.contents
 ,extent_management
 ,data.Mbytes "SPACE(MB)"
 ,free.free   "FREE(MB)"
 ,trunc((data.Mbytes-free.free)/data.Mbytes*100,2) "Used(%)"
FROM ( select
     tablespace_name name
    ,trunc(sum(bytes/1024/1024)) Mbytes
   from dba_data_files
         group by tablespace_name
      ) data,
  ( select
      free.tablespace_name
     ,trunc(sum(free.bytes)/1024/1024,1) free
   from dba_free_space free
  group by free.tablespace_name
  ) free,
dba_tablespaces ts
WHERE data.name = free.tablespace_name
  AND data.name = ts.tablespace_name
;