avg(kbytes_page_in) c3,
avg(kbytes_page_out) c4,
avg(user_cpu) c5,
avg(system_cpu) c6,
avg(idle_cpu) c7
from
perfstat.stats$vmstat
where
(user_cpu + system_cpu) > 70
and start_date > sysdate-&1
group by
server_name,
to_char(start_date,'yy/mm/dd hh24')
order by
server_name,
to_char(start_date,'yy/mm/dd hh24')
;
# vmstat_alert.ksh
#----------------------------------------
# 可以将此shell加入cron中，每天7点运行
#----------------------------------------
#!/bin/ksh
#----------------------------------------
# 首先设定环境变量，根据实际环境修改. . . .
