Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle
Originally Published: 2020-04-13
Article Number
Applies To
RSA Version/Condition: 7.1.1
Issue
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;
Cause
Resolution
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.
Notes
Related Articles
RSA Identity Governance and Lifecycle 7.2.1 Patch 3 Release Notes 19Number of Views RSA Identity Governance and Lifecycle 7.2.0 Patch 08 Release Notes 9Number of Views Role Membership Rule Difference Rule fails to run at scheduled time in RSA Identity Governance & Lifecycle 145Number of Views Data collection fails with error "java.lang.ArithmeticException: / by zero" in RSA Identity Governance & Lifecycle 50Number of Views Role appears in a "Changed" state during Role Review even after undoing all actions in RSA Governance & Lifecycle 3Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide The Template ({Connector Template Name}) has missing file content error when creating AFX Connectors in RSA Identity Gover… Troubleshooting RSA MFA Agent for Microsoft Windows RSA Release Notes for RSA Authentication Manager 8.8
Don't see what you're looking for?