본문 바로가기
OraclE

FILESYSTEMIO_OPTIONS

by 타마마임팩트_쫀 2014. 7. 22.

[출처] Oracle database Documentation Library 10g Release 2 (10.2)

FILESYSTEMIO_OPTIONS Initialization Parameter

You can use the FILESYSTEMIO_OPTIONS initialization parameter to enable or disable asynchronous I/O or direct I/O on file system files. This parameter is platform-specific and has a default value that is best for a particular platform. It can be dynamically changed to update the default setting.

FILESYTEMIO_OPTIONS can be set to one of the following values:

  • ASYNCH: enable asynchronous I/O on file system files, which has no timing requirement for transmission.

  • DIRECTIO: enable direct I/O on file system files, which bypasses the buffer cache.

  • SETALL: enable both asynchronous and direct I/O on file system files.

  • NONE: disable both asynchronous and direct I/O on file system files.


FILESYSTEMIO_OPTIONS

PropertyDescription
Parameter typeString
SyntaxFILESYSTEMIO_OPTIONS = { none | setall | directIO | asynch }
Default valueThere is no default value.
ModifiableNo
BasicNo

FILESYSTEMIO_OPTIONS specifies I/O operations for file system files.