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

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy


  Oracle Tips by Burleson

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

Server Generated Alerts

Oracle Database 10g has features that help the DBA reduce the time spent on database monitoring tasks by automatically notifying the DBA of performance or resources allocation issues and suggesting remedial actions. A server-generated alert is a notification message from the server of an impending problem.

Whenever a database metric does not match expected values or thresholds levels on different metrics are reached, an alert will be issued. This notification will contain the error/alert condition, and may contain suggestions for correcting the problem. Alerts are also generated when the problem condition has been cleared.

MMON helps by regularly scheduling monitoring actions. MMON can also be invoked when unusual conditions are detected in foreground processes by sending an alert. These alerts contain a description of the problem and advice on fixing the problem. OEM previously collected many of these alerts. Besides these alerts, by using the history of metric values in the workload repository, many database components self-tune.

The main difference between OEM alerts and server generated alerts is that with server generated alerts the metrics computation and threshold validations are performed by Oracle Database 10g and not by the OEM agent.

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:

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 -2017 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