|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version/Condition: 7.0.x, 7.1.x
|Issue||Starting in Oracle 12c, there is a new database parameter called TEMP_UNDO_ENABLED. RSA Identity Governance & Lifecycle Engineering recommends this parameter be enabled for use with the RSA Identity Governance & Lifecycle application.|
The reason for this recommendation is to improve performance and reduce disk space usage. This parameter is used to move the UNDO/REDO activity generated by temporary table activity from the regular UNDO tablespace to TEMP tablespace. This reduces the time and space needed for flashback recovery, backups, redo logs, and archived redo logging (if enabled) as less data is generated to the UNDO tablespace and to the redo logs.
Because RSA Identity Governance & Lifecycle makes heavy use of temporary tables (particularly GTT or global temporary tables), the application can benefit from enabling this parameter.
Per the Oracle documentation:
"If database applications make use of temporary objects (using global temporary tables or temporary table transformations), it is advisable to set this parameter's value to true."
For additional information on this setting, please refer to the Oracle documentation mentioned above.
The TEMP_UNDO_ENABLED parameter may be enabled using the alter system command as follows:
The next time the database is restarted the parameter will be in effect.