Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle
Originally Published: 2020-04-13
Last Modified: 2023-10-06
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
Slow response time on Requests tab in RSA Governance & Lifecycle 108Number of Views RSA Identity Governance and Lifecycle 7.0.1 rule pre-processing taking longer time to complete 57Number of Views Provisioning Termination rule is not generating change requests to disable accounts in RSA Identity Governance and Lifecycle 131Number of Views Segregation of Duties (SOD) Rule fails with error 'ORA-30926: unable to get a stable set of rows in the source tables' err… 231Number of Views Segregation of Duties rule returns unwanted violations if the same entitlement definition exists in both entitlement sets … 38Number of Views
Trending Articles
How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Setup and Configuration Guide RSA SecurID Software Token Administrator's Guide
Don't see what you're looking for?