How accurate is ADDM?

  • From: "Best, David" <David.Best@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 4 Dec 2007 15:21:25 -0500

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?


Other related posts: