本文介绍Oracle10g数据库中的警报机制，当超过预设阈值或发生特定事件时，MMON进程会将警报消息放入预定义的消息队列中。文章还概述了与警报相关的数据字典视图，包括DBA_OUTSTANDING_ALERTS、DBA_ALERT_HISTORY和V$ALERT_TYPES，并提到了如何使用OracleEnterpriseManager进行警报通知。
If a threshold is exceeded or an event has occurred, MMON puts an “alert” (i.e.
message) on a predefined queue. (This queuing mechanism uses Oracle’s
Advanced Queuing feature. ) The 10g data dictionary has been updated for alerts:
DBA_OUTSTANDING_ALERTS describes the outstanding alerts in the
database.
DBA_ALERT_HISTORY lists a history of alerts that have been cleared.
V$ALERT_TYPES provides information such as group and type for each alert
We can then build notification mechanisms. Using Oracle Enterprise Manager it’s
easy to email administrator’s if an alert occurs.
For more information on Server-Generated Alerts see Chapter 4 of the Oracle10g
Database Administrator’s Guide (“Monitoring the Operation of Your Database”).
message) on a predefined queue. (This queuing mechanism uses Oracle’s
Advanced Queuing feature. ) The 10g data dictionary has been updated for alerts:
DBA_OUTSTANDING_ALERTS describes the outstanding alerts in the
database.
DBA_ALERT_HISTORY lists a history of alerts that have been cleared.
V$ALERT_TYPES provides information such as group and type for each alert
We can then build notification mechanisms. Using Oracle Enterprise Manager it’s
easy to email administrator’s if an alert occurs.
For more information on Server-Generated Alerts see Chapter 4 of the Oracle10g
Database Administrator’s Guide (“Monitoring the Operation of Your Database”).
扫一扫
454
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
