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 Active Directory Account Data Collectors are failing in pre-processing 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 When does Rule Pre-processing occur for RSA Via L&G applications? Number of Views L&G: Why does rule pre-processing take place when rules are not scheduled Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
