[출처] 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
Property | Description |
---|---|
Parameter type | String |
Syntax | FILESYSTEMIO_OPTIONS = { none | setall | directIO | asynch } |
Default value | There is no default value. |
Modifiable | No |
Basic | No |
FILESYSTEMIO_OPTIONS
specifies I/O operations for file system files.
'OraclE' 카테고리의 다른 글
log_archive 파라미너 변경 (0) | 2014.08.05 |
---|---|
systemstate dump 와 hang analyze 수행 (0) | 2014.07.24 |
session 레벨 sql trace (0) | 2014.07.16 |
테이블 rename시 dependency는? (0) | 2014.07.07 |
ORA-14102: only one LOGGING or NOLOGGING clause may be specified (0) | 2014.06.18 |