How accurate is ADDM?

From: Best, David <David.Best_at_cognos.com>
Date: Tue, 4 Dec 2007 15:21:25 -0500
Message-ID: <2B4E386EAEC90947802323BF373DC0EC0CEEF92A@sottemail1.ent.ad.cognos.com>

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

Received on Tue Dec 04 2007 - 14:21:25 CST