Rule Pre-processing is slow in RSA Identity Governance & Lifecycle
Originally Published: 2020-07-16
Article Number
Applies To
RSA Version/Condition: 7.1.0, 7.1.1, 7.2.0
Issue
An AWR report may show the following query as a top consumer:
3zj0h93pydczf DELETE FROM T_AV_UA_RULE_COVERAGE RC WHERE RC.RULE_ID = :B1
For information on how to generate an AWR report, see RSA Knowledge Base Article 000037779 -- How to generate an Oracle Automatic Workload Repository (AWR) report for RSA Identity Governance & Lifecycle.
Cause
An index on internal table T_AV_UA_RULE_COVERAGE (the table in the query from the AWR) is defined incorrectly.
Resolution
Related Articles
Rules Pre-processing is queued twice during the same Collection cycle in RSA Identity Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle 7.0.1 rule pre-processing taking longer time to complete Number of Views Active Directory Account Data Collectors are failing in pre-processing in RSA Identity Governance & Lifecycle Number of Views When does Rule Pre-processing occur for RSA Via L&G applications? Number of Views Collection Data Pre-Processing takes longer and longer to complete in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to recover the Application and AFX after an unexpected database failure in RSA Identity Governance & Lifecycle RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle Provisioning-Termination Rule fails to filter on Custom Attributes that have the same Display Names across Multiple Object… RSA Release Notes for RSA Authentication Manager 8.8
Don't see what you're looking for?
