Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!c13g2000cwb.googlegroups.com!not-for-mail
From: wagen123@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: DBWR Tuning
Date: 12 Dec 2004 19:02:38 -0800
Organization: http://groups.google.com
Lines: 18
Message-ID: <1102906957.981203.92230@c13g2000cwb.googlegroups.com>
NNTP-Posting-Host: 68.39.97.164
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1102906962 8407 127.0.0.1 (13 Dec 2004 03:02:42 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 13 Dec 2004 03:02:42 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: c13g2000cwb.googlegroups.com; posting-host=68.39.97.164;
   posting-account=sme3wA0AAADvbfxJ6Q1vvOeoYaYjn0Wt
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:231437

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

