Re: Multiple DB writers vs. I/O slaves

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 18 Jul 2001 12:19:52 +0100 (BST)
Message-ID: <qKh*2Wv1o@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/

Received on Wed Jul 18 2001 - 06:19:52 CDT