[오라클] DB용량체크

SELECT t.tn AS tn
      ,TO_CHAR(TRUNC(((f.fs/t.ts)*100),2))||'% ' AS freep
      ,TO_CHAR(TRUNC((((t.ts-f.fs)/t.ts)*100),2))||'%' AS usedp
      ,t.ts AS bts
      ,(t.ts-f.fs) AS used
      ,f.fs AS free
FROM (SELECT tablespace_name AS tn
            ,SUM(bytes/1024/1024) AS ts
      FROM dba_data_files
      GROUP BY tablespace_name) t
    ,(SELECT tablespace_name AS tn
            ,SUM(bytes/1024/1024) AS fs
FROM dba_free_space
      GROUP BY tablespace_name) f
WHERE t.tn=f.tn(+)
AND t.tn NOT LIKE 'SYSTEM'
--ORDER BY t.tn
ORDER BY freep DESC;