Search notes:

Oracle: Init parameter FILESYSTEMIO_OPTIONS

filesystem_options controls whether Oracle files are accessed with asynchronous I/O and/or direct I/O.
The value of filesystem_options can be set to
none Synchronous and buffered I/O
setall Asynchronous and direct I/O
directIO Synchronous and direct I/O
async Asynchronous and buffered I/O
Obviously, asynchronous I/O and/or direct I/O will only be used if it's available (regardless of the setting of this init parameter).
Asynchronous I/O can also be disabled by setting disk_async_io) to false.
Because ASM bypasses the filesystem layer, filesystem_options has no effect when ASM is used.

See also

MOS Note 1987437.1
init parameters

Index