RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0, 7.1.1, 7.2.0
Rule Pre-Processing run time is slow in RSA Identity Governance & Lifecycle as seen under Admin
> Run Type: Rules Pre-processing.
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
This is a known issue reported in engineering ticket ACM-104642.
An index on internal table T_AV_UA_RULE_COVERAGE (the table in the query from the AWR) is defined incorrectly.
This issue is resolved in RSA Identity Governance & Lifecycle 7.2.0 P03.