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 Segregation of Duties rule returns unwanted violations if the same entitlement definition exists in both entitlement sets … 38Number 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
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?