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
RSA Identity Governance and Lifecycle 7.0.1 rule pre-processing taking longer time to complete Number of Views Collection Data Pre-Processing takes longer and longer to complete in RSA Identity Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle 7.1.1 Release Notes Number of Views RSA Identity Governance and Lifecycle 7.1.1.2 Release Notes Number of Views SecurID Governance & Lifecycle 7.5.2 Patch 11 Release Notes Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?
