Re: how to configure async io on windows 2003 server ntfs system

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 20 Nov 2005 16:01:04 +0100
Message-ID: <ps31o1dbk7qt7m0st0efmi3aen5oisl5mc@4ax.com>

On 20 Nov 2005 05:27:29 -0800, "lsllcm" <lsllcm_at_gmail.com> wrote:

>I have oracle 9.2.0.7 on two windows 2003 servers. When I run a sql
>with sort operation, the server 1 runs quicklier that server 2. There
>are a lot of wait events "direct path write/read" on server 2.
>
>I am not sure what causes this. I guess it is caused by direct io or
>async io configuration on the windows 2003 server. but I don't know how
>to check and configure the direct io and async io on windows 2003
>server.
>
>Could you help on this?
>
>Thanks in advance.

Windows has async I/O by default.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Nov 20 2005 - 09:01:04 CST