Re: Multiple DB writers vs. I/O slaves

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 18 Jul 2001 15:10:49 +1000
Message-ID: <3b551a15@usenet.per.paradox.net.au>

Since DBWR has absolutely nothing to do with inserts, adding multiple DBWRs isn't going to speed inserts up.

However, if you mean that you wish to speed up the DBWR flushes, then, yes, multiple DBWRs are a better way to go than I/O Slaves. I/O Slaves only parallelize the writing of blocks to disk: there's still a single DBWR collating the write batch.

With multiple DBWRs, the collation of the write batch is done in parallel, as well as the actual writing down to disk.

Regards
HJR "James Williams" <willjamu_at_mindspring.com> wrote in message news:3b50835f.69084259_at_nntp.mindspring.com...
> I have a DBMS with a large buffer pool 100000 buffers that is
> constantly being inserted into. Solaris 2.6 with one DB_Writer and 20
> I/O slaves with ASYNC I/O. Considering adding multiple DBWR processes
> to speed inserts. Oracle 8.1.6.3. 8k blocksizes.
>
> Read the various Metalink doc's but they are wishy washy.
>
>
Received on Wed Jul 18 2001 - 00:10:49 CDT