Oracle tablespace监控项目版 - 数据库编程

E_03.UNCM,
'本月累计总计：' || SUM(ESTIMATE_01.CM),'上月增值总计：' || SUM(ESTIMATE_01.LM),
'未加入监控总计：' || TRUNC((ESTIMATE_03.UNCM - ESTIMATE_02.SUMS),6)
FROM ESTIMATE_01,
(SELECT SUM(TT.IGBYTES)|| '' SUMS,TRUNC(SUM(DECODE(TT.STATUS,'9',TT.IGBYTES,0)),6)|| '' UNM
FROM DATAFILES_GE_MONITORING TT) ESTIMATE_02,

(SELECT TRUNC(SUM(BYTES)/ 1024 / 1024 / 1024,6) || '' UNCM FROM DBA_DATA_FILES) ESTIMATE_03
GROUP BY ESTIMATE_02.SUMS,ESTIMATE_02.UNM,ESTIMATE_03.UNCM;
SPOOL OFF;
ANALYZE TABLE DATAFILES_GE_MONITORING COMPUTE STATISTICS;

作者“Clement Ge 的专栏”

Oracle tablespace监控项目版(四)