Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
  Oracle Tips by Burleson

Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database Diagnostic Monitor

Server Generated Alerts

In Oracle 10g, the SGA can be accessed directly and the MMON wakes up every minute to compute the metric values. For those metrics with thresholds, MMON verifies these values and generates alerts as needed. Alerts based on threshold levels can be triggered at warning levels and critical levels. These levels can be internally set, customer defined, or customer altered from preset values.

There are two kinds of server generated alerts, threshold alerts and non-threshold alerts. Most alerts are configured by setting two threshold values on database metrics, a warning threshold and a critical threshold. These threshold alerts are also known as stateful alerts, which are automatically cleared upon fixing the alert condition. Stateful alerts are stored in dba_outstanding_alerts and are moved to dba_alert_history when cleared. Table 4.3 describes the structure of the dba_outstanding_alerts view

COLUMN

DESCRIPTION

SEQUENCE_ID

Sequence number for the Alert

REASON_ID

Alert reason ID

OWNER

Object owner for which the alert was issued

OBJECT_NAME

Object Name

SUBOBJECT_NAME

Sub-object Name

OBJECT_TYPE

Object type

REASON

Alert's Reason

TIME_SUGGESTED

Time of last update for the alert

CREATION_TIME

Time of first creation of the alert

SUGGESTED_ACTION

Recommended action

 


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

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks