Re: Multiple DB writers vs. I/O slaves

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 19 Jul 2001 14:31:28 +1000
Message-ID: <3b566265@usenet.per.paradox.net.au>

"Andrew Mobbs" <andrewm_at_chiark.greenend.org.uk> wrote in message
news:qKh*2Wv1o_at_news.chiark.greenend.org.uk...

> Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote:
> >>
> >
> >thanks for that info, Howard. IIRC, multiple DBWRs are still useful
> >in some heavy write situations even when ASYNC I/O is being used. Is
> >that still the case even with 8i?
>
> IME, yes.
>
> I think the explaination is that Oracle divides the LRU lists between
> the DBWRs, so if the work of walking the lists to find dirty blocks is
> becoming significant, multiple DBWR may still help.
>
> --
> Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Took the words right out of my mouth, Andrew! Thanks

Regards
HJR Received on Wed Jul 18 2001 - 23:31:28 CDT