Using Database Alerts with Metrics

Oracle Database 10g helps to reduce the time spent by the DBA on routine database-monitoring tasks by automatically sending messages with information about performance or resources-allocation issues and suggesting remedial actions.

A server-generated alert from the Oracle Database 10g server is a perfect example of a notification message about an impending problem. This message contains details about the error/alert condition and may contain recommendations for fixing the problem. Server-based alerts can also be based on threshold levels of different metrics, as explained earlier in this chapter.

MMON schedules the database-monitoring actions as explained earlier in this chapter. If the database detects any ...

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.