ORACLE查看剩余表空间

ORACLE查看剩余表空间

WITH df AS
 (SELECT tablespace_name, round(SUM(bytes) / 1024 / 1024) totalspace
    FROM dba_data_files
   GROUP BY tablespace_name),
fs AS
 (SELECT tablespace_name, round(SUM(bytes) / 1024 / 1024) freespace
    FROM dba_free_space
   GROUP BY tablespace_name)
SELECT df.tablespace_name "Tablespace", (df.totalspace - nvl(fs.freespace, 0)) "Used MB",
       nvl(fs.freespace, 0) "Free MB", df.totalspace "Total MB",
       round(100 * (nvl(fs.freespace, 0) / df.totalspace)) "Pct. Free"
  FROM df
  LEFT OUTER JOIN fs
    ON (df.tablespace_name = fs.tablespace_name)
 WHERE df.tablespace_name = 'SYSTEM';