Salesforce

Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle

« Go Back
Header
Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle
Slow-INSERT-statement-executing-from-the-SoD-Rule-Pkg-in-RSA-Identity-Governance-Lifecycle
Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle
Work in Progress
1,497.96
Article Content
 
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.1
 
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.
 
INSERT INTO GTT_BUCKET1_APPS
	(APPLICATION_ID, APP_CORRELATION_ATTRIBUTE, RULE_ID)
	SELECT APPLICATION_ID, APP_CORRELATION_VALUE, RULE_ID FROM 
	(
	  SELECT GTT.APPLICATION_ID, CAV.COLUMN_VALUE AS APP_CORRELATION_VALUE, GTT.RULE_ID
	  FROM GTT_BUCKET1_VIOLATIONS GTT,
	  TABLE(UTILITIES_PKG.TOKENIZER(APP_CORRELATION_ATTRIBUTE,',')) CAV
	)
	MINUS
	SELECT APPLICATION_ID, APP_CORRELATION_ATTRIBUTE, RULE_ID FROM GTT_BUCKET1_APPS;

 
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.
 
Disable the parameter TEMP_UNDO_ENABLED:
 
Login to SQL as SYS user
 
SQL> alter session set temp_undo_enabled=false scope=both;

By setting scope=both, this parameter will take effect immediately and will remain in effect after a system reboot.

 
000038720
Article Settings
External
Case
Diane McCoy
4/13/2020 5:02 PM
Diane McCoy
Article Assignment
 
 
 
Article Properties
Published
Knowledge
000049753
Diane McCoy
Katrina Nash
English

Powered by