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

Home -> Community -> Mailing Lists -> Oracle-L -> FILESYSTEMIO_OPTIONS (AIX 5.2 ML06, 9.2.0.5, JFS2)

FILESYSTEMIO_OPTIONS (AIX 5.2 ML06, 9.2.0.5, JFS2)

From: Stuart Clowes <stuart.clowes_at_gmail.com>
Date: Thu, 15 Jun 2006 17:36:45 +0100
Message-ID: <8cb0040f0606150936pc3a2863u99689a203d2d4321@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 15 2006 - 11:36:45 CDT

Original text of this message

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