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.0.1 rule pre-processing taking longer time to complete 57Number of Views RSA Governance & Lifecycle Data Processors: Basics 71Number of Views Attribute change rule creating duplicate change items for users having more than one account with same entitlement in an a… 35Number of Views SailPoint IdentityIQ 8.1 - End User Logon Experience - SecurID Access Implementation Guide 24Number of Views RSA Governance & Lifecycle 7.5.2 Release Notes 37Number of Views
Trending Articles
Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update Authentication Manager How to Retrieve the LDAPS Certificate and Configure an External Identity Source to Use LDAPS
Don't see what you're looking for?