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

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 20 Nov 2005 14:55:19 +0100
Message-ID: <4380804a$0$18242$ba620e4c@news.skynet.be>

"lsllcm" <lsllcm_at_gmail.com> wrote in message news:1132493249.220693.177630_at_z14g2000cwz.googlegroups.com...
>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.
>

I believe Windows Server 2003 always uses direct i/o, since there is no memory buffer cache. And I don't think it's possible to configure async i/o, that's why you should use a UNIX or Linux system :-)

Matthias Received on Sun Nov 20 2005 - 07:55:19 CST