| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How accurate is ADDM?
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_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Best, David
Sent: Tuesday, December 04, 2007 3:21 PM
To: oracle-l_at_freelists.org
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
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 04 2007 - 15:08:33 CST
 |
 |