文档库

最新最全的文档下载
当前位置:文档库 > Oracle-Alerts--与-Metrics(警告与度量)说明

Oracle-Alerts--与-Metrics(警告与度量)说明

Oracle Alerts 与 Metrics(警告与度量)说明Oracle Alerts 与 Metrics(警告与度量)说明


一.Alerts 和 Metrics说明官方链接:
Monitoring and Tuning the Database
http://www.wendangku.net/doc/f758fb1f227916888486d78d.html /cd/E11882_01/server.112/e10897/montune.htm#CACCIHAB

Alerts help you monitor your database. Most alerts notify youof when particularmetric thresholds are exceeded.For each alert, you can set critical and warning threshold values. Thesethreshold values are meant to be boundary values that when exceeded, indicatethat the system is in an undesirable state. For example, when a tablespacebecomes 97 percent full, this can be considered undesirable, and OracleDatabase generates a critical alert.
--Alerts 可以帮助我们监控数据库,大部分alerts 信息都是超过metric thresholds。 对于每一个alert,都可以设置critical和 warning threshold值。 当系统达到这个alert时,就说明这个指标已经处于异常状态。 比如当表空间使用了97%,那么就可以认为已经异常,数据库就会生成一条critical alert。

这些信息在OEM 上都可以很直观的查看。
企业管理器(OEM)介绍: Grid Control 和DatabaseControl
http://www.wendangku.net/doc/f758fb1f227916888486d78d.html /tianlesoftware/article/details/5704374

Oracle OEM 重建 及 案例 说明
http://www.wendangku.net/doc/f758fb1f227916888486d78d.html /tianlesoftware/article/details/4702978

Other alertscorrespond to database events such as Snapshot Too Old or Resumable Sessionsuspended. These types of alerts indicate that the event has occurred.
另一种alerts与db events 相关,如snapshot too old或resumable sessionsuspended。 当发生这些alert时,就会生成对应的alert。

In addition tonotification, you can set alerts to perform some action such as running ascript. For instance, scripts that shrink tablespace objects can be useful fora Tablespace Usage warning alert.

By default, Oracle Database issues severalalerts, including the following:
--默认情况下,oracle会发布如下的alerts:
(1)Archive Area Used (warning at80 percent full)
(2)Broken Job Count and Failed JobCount (warning when goes above 0)
(3)Current Open Cursors Count(warning when goes above 1200)
(4)Dump Area Used (warning at 95percent full)
(5)Session Limit Usage (warning at90 percent, critical at 97 percent)
(6)Tablespace Space Used (warningat 85 percent full, critical at 97 percent full)

You can modify these alerts and others bysetting their metrics.
这些alerts 和其他的Metrics 值都可以使用DBMS_SERVER_ALERT包的SET_THRESHOLD,GET_THRESHOLD 方法来修改和查看,也可以直接使用OEM来进行修改。

与Alerts 相关的数据字典如下表:

View
Description
DBA_THRESHOLDS
Lists the threshold settings defined for the instance
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 inform

免费下载Word文档免费下载: Oracle-Alerts--与-Metrics(警告与度量)说明

(共4页)