Oracle Internals Notes


The hidden _filesystemio_options parameter was introduced in Oracle version 8.1.7 to control the use of program selectable direct I/O and asynchronous I/O against file system based database files. It is no longer a hidden parameter from release 9.2 onwards. The following table shows the values that can be used when setting this parameter.

 Buffered I/ODirect I/O
Synchronous I/OnonedirectIO
Asynchronous I/Oasynchsetall

Databases that use a combination of say raw log files and raw tempfiles with file system based datafiles may wish to use kernelized asynchronous I/O against the raw files, but to avoid inefficient threaded asynchronous I/O against the datafiles. This can be done by allowing disk_asynch_io to default to TRUE, but setting filesystemio_options to either none or directIO. Similarly, the parameter may need to be set to either directIO or setall to avoid buffered I/O against file systems that support direct I/O but do not provide a direct I/O mount option. The default value for this parameter is asynch, regardless of the disk_asynch_io parameter setting.

Ixora Pty Ltd.   All rights reserved.
12-Oct-2007 22:22
Search   Questions   Feedback   Up   Home