Article Content
Article Number | 000035132 |
Applies To | RSA Product Set: RSA Identity Governance and Lifecycle RSA Version/Condition: All Platform (Other): Non-ASM Oracle database instances (soft-appliance and/or remote databases) |
Issue | For non-ASM (Oracle Automatic Storage Management) database implementations, RSA recommends the explicit setting of the FILESYSTEMIO_OPTIONS initialization parameter to SETALL in order to enable direct and asynchronous disk I/O. It can make a huge difference in storage performance. This is for non-ASM Oracle database implementations only. To determine if your Oracle database is an ASM implementation: Login as SYSDBA and run the following SQL command: $ sqlplus / as SYSDBA If this view returns no rows, then your system is a non-ASM Oracle implementation. For more information on the FILESYSTEMIO_OPTIONS initialization parameter, visit the Oracle web site.
|
Tasks | Check the current value of this parameter to see if it needs to be set. The default value is typically none. Login as sysdba, then run the following: SQL> SHOW PARAMETER FILESYSTEMIO_OPTIONS; If the value is something other than SETALL, it needs to be modified. For example, SQL> SHOW PARAMETER FILESYSTEMIO_OPTIONS; |
Resolution | Modify the FILESYSTEMIO_OPTIONS setting to SETALL, restart Oracle, and check that the setting has been modified:
SQL> ALTER SYSTEM SET FILESYSTEMIO_OPTIONS=SETALL SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE
SQL> SHOW PARAMETER FILESYSTEMIO_OPTIONS For example, $ sqlplus / as sysdba |