Understanding Oracle's Advisory Framework

While the AWR is revolutionary enough in its own right, the repository of performance information kept by the AWR provides DBAs with an entirely different set of tools, namely, the Advisory Framework. The Advisory Framework goes beyond the simple collection and presentation of statistics and metrics. It takes those metrics and uses them to give DBAs something all of us need at one time or another, that is, advice. The Advisory Framework can be a powerful tool in finding proactive and predictive solutions for several common performance problems.

Understanding the Automatic Database Diagnostic Monitor

Imagine that instead of spending hours interpreting the output of an AWR report, we could generate a report ...

Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide 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.