Re: DBWR slave process

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Tue, 18 Jun 2002 06:26:49 -0400
Message-ID: <aen1tc$8an2u$1@ID-82084.news.dfncis.de>

On Mon, 17 Jun 2002 20:28:51 -0400, Gaurang Patel wrote:

> Can anyone explain me about DBWR slave process?
>
> Since we have DBWR process what is the need of DBWR SLAVE process?
>
> I heard something like async i/o and DBWR SLAVE help to achivw that.
>
> How?
>
> Is there any other SLAVE process for other oracle processes
> like(LGWR,CKPT,ARCH ..etc)?
>
> Thanks

First, see whether you have any free buffer waits. Place to look is V$system event. If you do, then add another database writer process, which will automatically increase the number of lru latches and have much better effect hen io_slaves.

-- 
Mladen Gogala
In God We Trust. 
All others must provide data.

Received on Tue Jun 18 2002 - 05:26:49 CDT