OEM频繁报警 "Database Time Spent Waiting (%)"
本帖最后由 3000p 于 2016-2-24 17:07 编辑OEM频繁报警 "Database Time Spent Waiting (%)" is at 42.01582 for event class "Other" 查了下Database TimeSpent Waiting (%)的Other项的阀值发现默认是30%，我把测试机（11.2.0.4）的改成了5%，发现是生效的.BEGINDBMS_SERVER_ALERT.SET_THRESHOLD(1001, 0, 51, NULL, NULL, 1, 3, 'dev', 4, 'Other');END; 参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_server_alert.htm#ARPLS68004
因为，过一会查看dba_outstanding_alerts可以看到6%的警报信息。
但是，我在生产库（11.2.0.4的RAC）把Other的阀值改成80%，还是依旧收到超过30%的警报。感觉sql没有生效，但是查看dba_thresholds是生效的。
SQL> SELECT metrics_name,warning_operator,warning_value from dba_thresholds WHERE metrics_name='Database Time Spent Waiting (%)' AND object_name='Other';
METRICS_NAME WARNING_OPERATOR WARNING_VALUE
---------------------------------------------------------------- ---------------- --------------------------------------------------------------------------------
Database Time Spent Waiting (%) GT 80
Database Time Spent Waiting (%) GT 80
最近一次报警是在24-Feb-16 15:42:00下面是截取24-Feb-16 15:40:48到24-Feb-16 15:48:02的awr报告:
Top 10 Foreground Events by Total Wait Time
EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
DB CPU
357
100.5
log file sync2,19431.9Commit
enq: PS - contention158.74.2Other
db file sequential read170.63.2User I/O
control file sequential read1,418.20.1System I/O
enq: WF - contention15.18.0Other
IPC send completion sync371.10.0Other
Disk file operations I/O226.10.0User I/O
gc cr block 2-way132.10.0Cluster
reliable message129.10.0Other
Wait Classes by Total Wait Time
Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg Active Sessions
DB CPU
357
100.50.8
Commit2,19531.90.0
System I/O11,07830.80.0
Other14,75720.50.0
Network28,36410.40.0
User I/O53912.40.0
Concurrency2,10210.20.0
Cluster84500.10.0
Configuration208.00.0
Application12200.00.0
在itpub转了这个贴 http://www.itpub.net/thread-2053442-1-1.html
页:
[1]