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

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

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