DBWR Tuning

Giganews Newsgroups
Subject: DBWR Tuning
Posted by:  wagen1…@yahoo.com
Date: 12 Dec 2004

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

Replies