END)
WHEN TX.CURRENTWEEKGBYTES = 0 THEN
(CASE WHEN TX.LASTWEEKSGBYTES > 0 THEN
'Down Rate : ' || ROUND(TX.LASTWEEKSGBYTES*100,4) || '%'
ELSE
'Up Rate : ' || ROUND(TX.LASTWEEKSGBYTES*100,4) || '%'
END)
ELSE
(CASE WHEN TX.CURRENTWEEKGBYTES > 0 THEN
'Up Rate : ' || ROUND(TX.CURRENTWEEKGBYTES/TX.LASTWEEKSGBYTES*100,4) || '%'
ELSE
'Down Rate : ' || ROUND(TX.CURRENTWEEKGBYTES/TX.LASTWEEKSGBYTES*100,4) || '%'
END)
END) CLW,
TX.CURRENTMONTHGBYTES CM,
TX.LASTMONTHSGBYTES LM,
(CASE WHEN TX.LASTMONTHSGBYTES = 0 THEN
(CASE WHEN TX.CURRENTMONTHGBYTES >= 0 THEN
'Up Rate : ' || ROUND(TX.CURRENTMONTHGBYTES*100,4) || '%'
ELSE
'Down Rate : ' || ROUND(TX.CURRENTMONTHGBYTES*100,4) || '%'
END)
WHEN TX.CURRENTMONTHGBYTES = 0 THEN
(CASE WHEN TX.LASTMONTHSGBYTES > 0 THEN
'Down Rate : ' || ROUND(TX.LASTMONTHSGBYTES*100,4) || '%'
ELSE
END)
ELSE
(CASE WHEN TX.CURRENTMONTHGBYTES > 0 THEN
'Up Rate : ' || ROUND(TX.CURRENTMONTHGBYTES/TX.LASTMONTHSGBYTES*100,4) || '%'
ELSE
'Down Rate : ' || ROUND(TX.CURRENTMONTHGBYTES/TX.LASTMONTHSGBYTES*100,4) || '%'
END)
END) CLM
FROM DATAFILES_GE_MONITORING TX
WHERE TX.STATUS < '9'
ORDER BY TX.STATUS DESC,TX.IGBYTES DESC)
select DS "文件状态",TB "表空间名称",IG || '' "当前数据文件大小(G)",
CD || '' "当天数据量(G)",LD || '' "昨天数据量(G)",
CLD "前/后两天比率",
CW || '' "本周累计总值(G)",LW || '' "上周总值(G)",
CLW "前/后两周比率",
CM || '' "当月累计总值(G)",LM || '' "上月总值(G)",
CLM "前/后两月比率"
from ESTIMATE_01
UNION ALL
SELECT '统计汇总 ','监控总计：' || ESTIMATE_02.SUMS,'当前监控总计：' || SUM(ESTIMATE_01.IG),
'当天增值总计：' || SUM(ESTIMATE_01.CD),'昨天增值总计：' || SUM(ESTIMATE_01.LD),
'停止监控总计：' || ESTIMATE_02.UNM,
'本周累计总计：' || SUM(ESTIMATE_01.CW),'上周增值总计：' || SUM(ESTIMATE_01.LW),
'空间总计：' || ESTIMAT