DBA_OUTSTANDING_ALERTS 与 DBA_ALERT_HISTORY

最新推荐文章于 2026-09-10 15:14:53 发布

原创最新推荐文章于 2026-09-10 15:14:53 发布 · 806 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

当前文章被以下社区和专栏收录：

本文展示了如何使用Oracle的DBA_OUTSTANDING_ALERTS和DBA_ALERT_HISTORY视图来监控和诊断数据库性能问题。通过SQL查询按创建时间降序获取当前突出警告及历史警告，包括警告原因、建议操作和相关性能指标。

select * from DBA_OUTSTANDING_ALERTS order by creation_time desc
SEQUENCE_ID,REASON_ID,OWNER,OBJECT_NAME,SUBOBJECT_NAME,OBJECT_TYPE,REASON,TIME_SUGGESTED,CREATION_TIME,SUGGESTED_ACTION,ADVISOR_NAME,METRIC_VALUE,MESSAGE_TYPE,MESSAGE_GROUP,MESSAGE_LEVEL,HOSTING_CLIENT_ID,MODULE_ID,PROCESS_ID,HOST_ID,HOST_NW_ADDR,INSTANCE_NAME,INSTANCE_NUMBER,USER_ID,EXECUTION_CONTEXT_ID,ERROR_INSTANCE_ID
231145,107,,SYSTEM,,SYSTEM,Metrics "Current Open Cursors Count" is at 1424,2019-8-12 9:26:53.834023 +08:00,2019-8-12 9:26:53.834023 +08:00,Run ADDM to get more performance analysis about your system.,ADDM,1424,Warning,Performance,5,,SERVER MANAGEABILITY:kelr.c,"orcl"."orcl",hostname,ip_address,orcl,1,,,8FE26B47CAA6-000E-E053-0A30B268000E-0

select * from DBA_ALERT_HISTORY order by creation_time desc