Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: directio and async io on redhat linux 3 and oracle 9i

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

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sun, 08 May 2005 19:17:44 +1000
Message-ID: <427dd92c$0$22961$5a62ac22@per-qv1-newsreader-01.iinet.net.au>


chao_ping apparently said,on my timestamp of 8/05/2005 9:59 AM:

> redhat as 3 does support DIO, but need seperate patch as I said before.

Funny: the Oracle papers in metaclick claim that RH3 does NOT support direct IO for file systems and 9ir2. Only for NFS files.

> after applying patch 3186784:
> [oracle_at_db1 3186847]$ grep open 9204.directio
> open("/home/oracle/product/920/dbs/lkDB", O_RDWR|O_CREAT|O_EXCL, 0660)
> = -1 EEXIST (File exists)
> open("/home/oracle/product/920/dbs/lkDB", O_RDWR) = 10
> open("/home/oracle/oradata/db/control1.ctl",
> O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 11
> open("/home/oracle/oradata/db/system.dbf",

In fact, they claim that this happens only in NFS datafiles. That is what the patch you mentioned before (2448994) claims. this 3186784 patch is now different again.

I wonder: has Oracle support stooped so low that their advice now as to what a patch does is so completely wrong we have to test EVERY single grain of functionality to make sure their contents are what they claim?

Lovely...

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam
Received on Sun May 08 2005 - 04:17:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US