Re: On 10gR2, Do you trust ADDM?

owensmith99_at_gmail.com wrote:
> Oracle People,
>
> Do you trust ADDM?
>
> I am a novice AWR user.
>
> I am looking at an AWR report. I am uncomfortable with the amount
> of information it is giving me; it's huge.
>
> In DBControl, when I run ADDM against a given AWR report,
> I'm comforted by the comprehensive nature of the ADDM report.
>
> Are you Oracle People comfortable with level of advice you obtain from
> ADDM reports?
>
> I'm certain that a piece of software designed to give advice can be
> more systematic
> than I at following a checklist.
>
> But I'm worried that details might be lurking in the enormous AWR
> report which
> ADDM is not designed to handle.
>
> Related question:
>
> Where might I find examples of Performance Tuning "Experts" analyzing
> an AWR report?
>
> -Owen

To quote Ronald Reagan ... "trust but verify."

ADDM is not intended as a tool for the blind to be applied without intervention of synapses. Take the ADDM advice, apply it to a test environment and run tests to determine the impact. Then, and only then, apply to production ... unless the activity recommended is one where ... to paraphrase the Hippocratic Oath: "Do no harm" you know you can safely apply it without consequence.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org