Re: DBWR setting on NT ?

Just wondering how safe this i/o mode is when a server crashes: does NT protect the file system under async i/o, and how? How does this compare to unix?

On Fri, 17 Oct 1997, sm wrote:

> 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 Tue Oct 21 1997 - 00:00:00 CDT