Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How accurate is ADDM?

Re: How accurate is ADDM?

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Wed, 5 Dec 2007 06:48:07 +0300
Message-ID: <97b7fd2f0712041948w45a98743xcd7dea29dcc594fa@mail.gmail.com>


We use ADDM report as a quick starting point to investigate the database issues instead of taking the awr reports, analyzing them to understand the problems.

Regards,

jaffar

On 12/4/07, Best, David <David.Best_at_cognos.com> wrote:
>
>
> Hey all,
>
> How accurate is ADDM? Today we had a severe performance issue with
> one our of databases. The ADDM recommendation for that period put the
> most weight on the following:
>
> ---[ADDM Snip]---
> Action Investigate the possibility of improving the performance of I/O
> to the online redo log files.
>
> Rationale The average size of writes to the online redo log files was
> 932 K and the average time per write was 3020 milliseconds.
> ---[ADDM Snip]---
>
>
> The problem is, our storage team doesn't see the same level of
> degredation. Any suggestions?
>
> tnx
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 04 2007 - 21:48:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US