Re: DBWR, Direct I/O and the Devil

From: Don Seiler <don_at_seiler.us>
Date: Wed, 28 Nov 2007 13:38:42 -0600
Message-ID: <716f7a630711281138m4572dce4ufa442f2705f209ba@mail.gmail.com>

On Nov 28, 2007 1:32 PM, Taylor, Chris David <Chris.Taylor_at_ingrambarge.com> wrote:
> Do you believe you have an I/O issue or are you just trying to "squeeze"
> more out of your I/O subsystem?

Right now I just want to know that I don't have some horribly obvious (to everyone else) misconfiguration. Obviously having a stable setup is paramount, I'll worry about tuning again after that. With my recent rash of performance issues, I'm going through any and all configuration changes that I made in the past 3 months and questioning everything.

> Having played with db_writer_processes, I haven't really seen much
> improvement or negative impact from increasing/decreasing them. But
> that is probably more due to the load (or lack thereof to notice any
> difference).

As I said, I'm all in favor of dropping down to 1, maybe back up to 2 if need be. I just wanted to know if there's any concerns to be aware of with the number of DBWR processes in direct vs. asynch I/O.

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 28 2007 - 13:38:42 CST