Re: DBWR setting on NT ?

Hmm... DBWR setting? Are you referring to the setting that specifies the number of DBWRs?
Well, you can set it to whatever you want... but the max number of DBWRs on NT is 1. Multiple DBWRs are used on ports which do not provide async I/O. As NT provides async I/O, 1 is sufficient.

Have you tried increasing the number of db_block_buffers... ensure you have enough RAM for it.

-sm

On 14 Oct 97 17:27:41 MDT, sl3r9_at_cc.usu.edu wrote:

>
>I want to know what an optimum setting for DBWR would be
>for Oracle running on an NT3.51, multiuser environment
>(about 150 users-OLTP) and about 4-5 batch processes
>running daily.
>I was thinking a DBWR=5 or 6 would be sufficient.
>I am seeing a large number of data block contention,
>and this could be because of DBWR. By setting a DBWR
>value, what other effects could be taking place and
>do I need to consider any other aspects for reducing
>this contention.
>Thanks a bunch.
>Raghu
Received on Fri Oct 17 1997 - 00:00:00 CDT