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 FIM error 'The specified role is not defined in Entity' 19Number of Views How to enable SQL Statement tracing in SQL Server? 35Number of Views If the RSA Identity Governance and Lifecycle Rule Status is invalid, a Segregation of Duties (SOD) rule definition takes … 51Number of Views Segregation of Duties rule returns unwanted violations if the same entitlement definition exists in both entitlement sets … 39Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?