FreeLists / oracle-l / RE: How accurate is ADDM?

["Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>]

Have you confirmed the write time by generating an AWR report for that
time period and seeing what the average wait for log file parallel write
and log file sync is? 


Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Best, David
Sent: Tuesday, December 04, 2007 3:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: How accurate is ADDM?


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




==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
http://www.freelists.org/webpage/oracle-l