Oracle tablespace 监控项目版(三)

2014-11-24 18:29:00 · 作者: · 浏览: 4
TES,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;