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
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.
