DBWR Tuning

Oracle9i 9.2.0.5 (64 bit)
Solaris 2.9 (64 bit)
RAID 0+1
OLTP db

Ref: Steve Adams - The Mysteries of DBWR Tuning

We are trying to address the question "should we have multiple DBWR processes?"

My understanding is that - If one does not see any wait events related to "free buffer waits" OR "write complete waits", DBWR tuning is not required and multiple DBWR processes is not required. Open to suggestions.

Thanks
wagen Received on Sun Dec 12 2004 - 21:02:38 CST