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 Authentication Manager 8.1 backups are not listed in the Operations Console Number of Views Steps for replacing a faulty hard drive on RSA SecurID Appliance 250 Number of Views How to disable weak or non-FIPS compliant Ciphers in Authentication Manager v.8.8 or Identity Router v. 12.24.0.x.x Number of Views
Trending Articles
RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA Announces the Release of RSA MFA Agent 2.5 for Microsoft Windows How to Download OTP Token Seed Files from myRSA
Don't see what you're looking for?
