avg(user_cpu + system_cpu) c5,
avg(system_cpu) c6,
avg(idle_cpu) c7
from stats$vmstat
where trunc(start_date) = to_date(&1,'yyyymmdd')
group by server_name,to_char(start_date, 'hh24')
order by server_name,to_char(start_date, 'hh24');
3) 周趋势报告
# rpt_vmstat_dy.sql
rem ----------------------------------------