Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBWR Tuning

Re: DBWR Tuning

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 14 Dec 2004 06:31:41 -0000
Message-ID: <41be88c8$0$16589$cc9e4d1f@news-text.dial.pipex.com>


"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1102988750.978267_at_yasure...
> I'm fine with it dying but want to say that, from experience,
> there is no hard and much good that comes from experimentation.
> All guidelines are just that ... guidelines. 8 is not more a
> "fact" than is any other integer. It is always best to test
> modifications to configurations.

I'll agree with all of that, and I'm a bit wary that it sounds like I'm having the last word. I'd just like to be on record as saying that *in general* you don't need one dbwr per cpu, not that you must wait until you have 8 cpus. Once again I'd be driven by the percieved performance of the system for the users. It seems to me that the performance tuning our job as dbas to translate 'my order entry screen is too slow' into specific technical steps, not to continually perform technical adjustments, because they 'seem' appropriate.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Tue Dec 14 2004 - 00:31:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US