DBA_OUTSTANDING_ALERTS 与 DBA_ALERT_HISTORY

最新推荐文章于 2021-04-11 15:04:32 发布

allway2

最新推荐文章于 2021-04-11 15:04:32 发布

阅读量765

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/allway2/article/details/99675149

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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