|Buffered I/O||Direct I/O|
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.