RE: FILESYSTEMIO_OPTIONS (AIX 5.2 ML06, 9.2.0.5, JFS2)

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <stuart.clowes@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 16 Jun 2006 11:24:04 -0700

You can see CIO in the FILE-FLAG column if you run lsof +fg, e.g.:
 
tarunx01:/home/abielewi:# /p570build/LSOF/lsof-4.76/usr/local/bin/lsof
+fg /baanprd/oradat
COMMAND     PID     USER   FD   TYPE              FILE-FLAG DEVICE
SIZE/OFF NODE NAME
oracle   434222   oracle   16u  VREG     R,W,CIO,DSYN,LG;CX   39,1
6701056  866 /baanprd/oradat (/dev/bprdoradat)
oracle   434222   oracle   17u  VREG     R,W,CIO,DSYN,LG;CX   39,1
6701056  867 /baanprd/oradat (/dev/bprdoradat)
oracle   442384   oracle   15u  VREG     R,W,CIO,DSYN,LG;CX   39,1
1174413312  875 /baanprd/oradat (/dev/bprdoradat)
oracle   442384   oracle   16u  VREG     R,W,CIO,DSYN,LG;CX   39,1
734011392  877 /baanprd/oradat (/dev/bprdoradat)
oracle   450814   oracle   15u  VREG     R,W,CIO,DSYN,LG;CX   39,1
1174413312  875 /baanprd/oradat (/dev/bprdoradat)
oracle   450814   oracle   16u  VREG     R,W,CIO,DSYN,LG;CX   39,1
1814044672  876 /baanprd/oradat (/dev/bprdoradat)
oracle   487666   oracle   15u  VREG     R,W,CIO,DSYN,LG;CX   39,1
1174413312  875 /baanprd/oradat (/dev/bprdoradat
 
You should also see O_CIO in your file open calls if you run truss,
e.g.:
 
open("/opt/oracle/rcat/oradat/redo01.log",
O_RDWR|O_CIO|O_DSYNC|O_LARGEFILE) = 18
 
HTH, 
Brandon

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stuart Clowes
Sent: Thursday, June 15, 2006 9:37 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: FILESYSTEMIO_OPTIONS (AIX 5.2 ML06, 9.2.0.5, JFS2)


How can I confirm that FILESYSTEMIO_OPTIONS is having an effect?
 
I an on AIX5.2 ML06;  
JFS2 filesystems mounted without dio or cio; and Oracle 9.2.0.5. AIO is
enabled.
 
# lsattr -El aio0
autoconfig available STATE to be configured at system restart True
fastpath   enable    State of fast path                       True
kprocprio  39        Server PRIORITY                          True 
maxreqs    16384     Maximum number of REQUESTS               True
maxservers 20        MAXIMUM number of servers per cpu        True
minservers 10        MINIMUM number of servers                True
 
 
 
I have trussed DBW0 (and LGWR).  
 
With DISK_ASYNCH_IO = FALSE and FILESYSTEMIO_OPTIONS=SETALL, I see
kpwrite calls
With DISK_ASYNCH_IO = FALSE and FILESYSTEMIO_OPTIONS=ASYNCH, I see
kpwrite calls.
With DISK_ASYNCH_IO = FALSE and FILESYSTEMIO_OPTIONS=NONE, I see kpwrite
calls
 
 
With DISK_ASYNCH_IO = TRUE and FILESYSTEMIO_OPTIONS=SETALL, I  see
listio64 and aio_nwait calls
With DISK_ASYNCH_IO = TRUE and FILESYSTEMIO_OPTIONS=ASYNCH, I  see
listio64 and aio_nwait calls.
With DISK_ASYNCH_IO = TRUE and FILESYSTEMIO_OPTIONS=NONE, I see listio64
and aio_nwait calls.
 
I expected to be able to 'turn off' asynch io if DISK_ASYNCH_IO = TRUE
and FILESYSTEMIO_OPTIONS=NONE. What have I missed?
 
 
This is just a preliminary up to my main question, which is validating
that concurrent I/O is also enabled as expected........
 
 
 

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: