Re: On 10gR2, Do you trust ADDM?

On Sep 10, 5:01 am, "owensmit..._at_gmail.com" <owensmit..._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

Taking blind advice from any tool whether it's ADDM and provided by oracle or 3rd party vendors is like walking into a 7 and 11 ( late night one stop mini food mart if that doesn't translate well ) with a sawed off shotgun.

You may end up walking out with a free slurpee but there may be many other bad consequences.

Unforunately ADDM in particular but really all of the automated tuning tools are best used by someone who doesn't particularly need them because they know what's behind the good, mediocre, and bad advice provided. Received on Mon Sep 10 2007 - 16:11:47 CDT