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 ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
