Re: DBWR setting on NT ?

From: sm <sm_at_nowhere.com>
Date: 1997/10/23
Message-ID: <344e9acd.606405254@newshost.us.oracle.com>#1/1

Well, asych i/o is used just for the datafiles. For the log files, Oracle waits for each block to be flushed to the disk (i/o buffers are bypassed). So, if the system crashes, when the rdbms is brought back, it uses the logfile to rollforward completed transactions and rollback the incomplete ones, in the datafiles.

I am not sure what you mean by NT protecting the file-system... however, as you can see, Oracle does not really require any hand holding from the OS.

-sm

On Tue, 21 Oct 1997 07:43:02 -0400, ECAPALDI <Ecapaldi_at_cris.com> wrote:

>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?
Received on Thu Oct 23 1997 - 00:00:00 CDT