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

From: chao_ping <zhuchao_at_gmail.com>
Date: 7 May 2005 16:59:02 -0700
Message-ID: <1115510342.711679.243510@z14g2000cwz.googlegroups.com>

redhat as 3 does support DIO, but need seperate patch as I said before. Without applying the patch:
[oracle_at_db1 3186847]$ grep open 920.directio
open("/home/oracle/oradata/db/data01.dbf", O_RDONLY|O_LARGEFILE) = 18 open("/home/oracle/oradata/db/data01.dbf", O_RDWR|O_SYNC|O_LARGEFILE) = 18
open("/home/oracle/oradata/db/data01.dbf", O_RDONLY|O_LARGEFILE) = 18 open("/home/oracle/oradata/db/data01.dbf", O_RDWR|O_SYNC|O_LARGEFILE) = 18
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", O_RDONLY|O_DIRECT|O_LARGEFILE) = 12
open("/home/oracle/oradata/db/system.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 12 open("/home/oracle/oradata/db/undo.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 13
open("/home/oracle/oradata/db/undo.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 13 open("/home/oracle/oradata/db/data01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 14
open("/home/oracle/oradata/db/data01.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 14 open("/home/oracle/oradata/db/index01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 15
open("/home/oracle/oradata/db/index01.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 15 open("/home/oracle/oradata/db/lob_data01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 16
open("/home/oracle/oradata/db/lob_data01.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 16 open("/home/oracle/oradata/db/temp.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 17
open("/home/oracle/oradata/db/temp.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 17 Received on Sat May 07 2005 - 18:59:02 CDT