Init parameterFiles & storage

FILESYSTEMIO_OPTIONS

What it controls

Asynchronous and direct I/O for datafiles on file systems.

Know this before you change it

SETALL enables both and is the usual choice on Linux file systems. It doesn't apply to ASM.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'filesystemio_options';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'filesystemio_options' AND isspecified = 'TRUE';8 9-- Static: saved in the spfile, takes effect after a restart10ALTER SYSTEM SET filesystemio_options = SETALL SCOPE = SPFILE SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET filesystemio_options SCOPE = SPFILE SID = '*';

Open in the parameter referenceOracle's reference

More in Files & storage

• DB_CREATE_FILE_DESTDefault location for Oracle-managed datafiles and tempfiles.
• DB_CREATE_ONLINE_LOG_DEST_NLocations for Oracle-managed online redo logs and control files. Numbered 1 to 5; each one holds a member of every group.
• CONTROL_FILESThe control file copies the instance opens at startup.
• DB_FILESThe most datafiles the database can have open.
• DEFERRED_SEGMENT_CREATIONWhether new tables and indexes get space only when the first row arrives.
• RECYCLEBINWhether dropped tables go to the recycle bin so they can be flashed back.
• MAX_STRING_SIZEEXTENDED raises VARCHAR2, NVARCHAR2 and RAW limits from 4000 to 32767 bytes.