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 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 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
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
