代码如下：
CREATE OR REPLACE VIEW DB_TBSPACE_CHECK AS
SELECT a.TBSPACE_NAME AS TBSPACE_NAME,
ROUND(a.Total_MB,2) AS Total_MB,
ROUND(b.Free_MB,2) AS Free_MB,
ROUND((NVL(a.Total_MB,0)-NVL(b.Free_MB,0)),2) AS Used_MB,
ROUND(DECODE(NVL(a.Total_MB,0),0,0,
(NVL(a.Total_MB,0)-NVL(b.Free_MB,0))*100/NVL(a.Total_MB,0)),2)||'%' AS Used_Rate,
ROUND(DECODE(NVL(a.Total_MB,0),0,0,
NVL(b.Free_MB,0)*100/NVL(a.Total_MB,0)),2)||'%' AS Free_Rate
FROM (SELECT TABLESPACE_NAME AS TBSPACE_NAME,
SUM(BYTES)/1024/1024 AS Total_MB
FROM DBA_DATA_FILES t
GROUP BY TABLESPACE_NAME) a,
(SELECT TABLESPACE_NAME AS TBSPACE_NAME,
SUM(BYTES)/1024/1024 AS Free_MB
FROM DBA_FREE_SPACE t
GROUP BY TABLESPACE_NAME) b
WHERE a.TBSPACE_NAME = b.TBSPACE_NAME
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20546452/viewspace-874496/ ，如需转载，请注明出处，否则将追究法律责任。
