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

To legally use ADDM and the AWR you need the EM Performance Pack option and this is an additional license fee.

>From what I have been able to gather from people who have tried to use
ADDM the ADDM sometimes provides good advice but often if does not. I think a DBA can live without it.

• Mark D Powell --