Re: Tuning

From: Laurent La Fosse <llafosse_at_mediaone.net>
Date: Mon, 14 Feb 2000 11:19:39 GMT
Message-ID: <fxRp4.4644$P6.93296@ndnws01.ne.mediaone.net>

You can add db_writers or use set async_io=true but not both at the same time.

Sanjeev K Singh wrote in message
<8873v6$54im$1_at_newssvr04-int.news.prodigy.com>...
>
>Hi Folks,
>
>Have a tuning question. When i select class = 'data block' from v$waitstat
i
>am getting a very high # in count. It seems like i have data block
>contention. What step should i take?
>
>Should i increase DB_WRITER ?
>
>Thanks,
>
>
>
>
>
Received on Mon Feb 14 2000 - 05:19:39 CST