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

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Fri, 16 Jun 2006 11:24:04 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C4503D40A82@NT15.oneneck.corp>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stuart Clowes Sent: Thursday, June 15, 2006 9:37 AM
To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 16 2006 - 13:24:04 CDT