|
|
| |
 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
Using PL/SQL Packages for Server Generated
Alerts
-
v$alert_types provides information
about group and type of each alert.
-
dba_outstanding_alerts
has the list of outstanding alerts in the database.
-
dba_alert_history has a
history of alerts that have been cleared.
-
dba_thresholds lists
the various threshold settings for the instance. The table shown
below describes the columns in this view.
|
COLUMN |
DESCRIPTION |
|
METRICS_NAME |
Metrics name |
|
WARNING_OPERATOR |
Relational operator for warning
threshold - GT, EQ, LT, LE, GE, CONTAINS, NE, DO NOT
CHECK |
|
WARNING_VALUE |
Warning threshold value |
|
CRITICAL_OPERATOR |
Relational operator for critical
threshold - GT, EQ, LT, LE, GE, CONTAINS, NE, DO NOT
CHECK |
|
CRITICAL_VALUE |
Critical threshold value |
|
OBSERVATION_PERIOD |
Duration of observation period in
minutes |
|
CONSECUTIVE_OCCURRENCES |
Number of occurrences before
issuing an alert |
|
INSTANCE_NAME |
Instance name - NULL for database
wide alerts |
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
|
|
