Introduction to ADDM

As mentioned in previous chapters, Oracle Database 10g comes with a number of advisors built in. For the performance analyst, the Automatic Database Diagnostic Monitor (ADDM) is the most important of the advisors and is indeed the starting point in the investigation of any performance issue. Affectionately called “ADDuM” or “ADAM,” this component of the Database Diagnostic Pack is a powerful aide to the performance analyst when it is understood and used carefully. Simply stated, it is a self-diagnostic mechanism built into the kernel that automatically examines and analyzes the AWR snapshots at the end of every snapshot with the objective of determining any performance-affecting issue. It is then able to recommend corrective ...

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.