Re: directio and async io on redhat linux 3 and oracle 9i

chao_ping wrote:
> Oracle metalink conflicted sometimes.

you're telling me? :)

> After applying the patch, When we check the DBWR
> We can clearly see the DIRECTIO in the open system call.
> open("/tmp/test.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 21

I plonked the patch in anyways and verified: it does indeed seem to use O_DIRECT.

<trace>
open("/blah/oradata/blah/blah_01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 27
</trace>

Unreal, eh? A patch supposedly for driect io in NFS fixes the normal ext3 IO...

> As oracle 10g on redhat 3 support directio as Gogala said, so it
means
> redhat 3 itself supports directio.

Yes, that was my understanding as well. But you never would know by reading the doco that 9.2.0.6 could also do it!

> So the problem is how oracle use directio on redhat 3, as the note
> says, they don't match, so we need a seperate patch for 9.2.0.4-6 to
> enablee directio.

Yup. Got it. Thanks a lot. Received on Sun May 08 2005 - 20:16:06 CDT