[출처] 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 |