|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Version/Condition: 7.0.2 P10+, 7.1.0 P03+, 7.1.1 GA
|Issue||After upgrading to 7.0.2 P10+, 7.1.0 P03+ or 7.1.1, certain activities related to change requests have significant performance degradation. Symptoms include:|
An Automatic Workload Repository (AWR) report during these time periods may show top executing SQL queries similar to the following:
|Cause||This problem is due to a missing index on column CRI_ID in table T_AV_EXPLODEDUSERENTITLEMENTS. The missing index forces a full table scan when deleting from this table and this is what causes the poor performance. CRI_ID is a new column added to the table starting in versions 7.0.2 P10, 7.1.0 and 7.1.1. Starting in 7.0.2 P10, 7.1.0 P03 and 7.1.1, there are changes to the scope of the deletes on that table requiring an index on column CRI_ID for optimal performance.|
|Resolution||To verify if you have this issue, first verify if you have the new column (CRI_ID). If so, then verify whether or not there is an index on the column.|
If this query returns no results, then you do not have this issue.
If this column returns a row, then you do not have this issue.
This issue is resolved in the following RSA Identity Governance & Lifecycle patches:
|Workaround||There is a script available to build the index. Please contact RSA Identity Governance & Lifecycle support for the script.|