Article Content
Article Number | 000038720 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: 7.1.1 |
Issue | The following INSERT statement executed by the SoD_Rule_Pkg (Segregation of Duties Rule Package) was reported as running too slow in RSA Identity Governance & Lifecycle during SoD rule execution.
|
Cause | The cause of this issue was never determined. However, we saw this issue worsened by enabling the TEMP_UNDO_ENABLED parameter. For more information on this parameter and its use with RSA Identity Governance & Lifecycle, see RSA Knowledge Base Article 000038718 -- Oracle 12c TEMP_UNDO_ENABLED parameter for managing GTT UNDO activity in RSA Identity Governance & Lifecycle. |
Resolution | Disable the parameter TEMP_UNDO_ENABLED: Login to SQL as SYS user
By setting scope=both, this parameter will take effect immediately and will remain in effect after a system reboot. |
Notes | See related RSA Knowledge Base Article 000038723 -- Poor performance when processing SoD Rules that use a Correlation Attribute in RSA Identity Governance & Lifecycle. |