O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Metrics Monitoring and Customization

Oracle Database 10g metrics are tracked using AWR. Each metric has threshold values associated with them. Whenever a metric value reaches its threshold, an alert is generated. Alerts are also generated when a previous alert is cleared, when a change in the availability of a monitored service occurs, or when a specific error condition or database action occurs. MMON wakes up every minute to check the metric values. For metrics with thresholds, MMON verifies those values and generates alerts as needed.

The database-usage metrics are divided into two broad categories: database feature usage and high water–mark (HWM) value of certain database attributes. These metrics are useful for getting an idea of any resource ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required