Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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.orgReceived on Mon Sep 10 2007 - 11:17:26 CDT
![]() |
![]() |