RSA Identity Governance and Lifecycle IDC Unification is slow in "Step 8/10: Post-Processing: Populate Role Metrics" after upgrading to 7.0.1

[#1]

Article Number

000034698

Applies To

RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.1
 

Issue

The RSA Identity Governance and Lifecycle 7.0.1 Identity Data Collectors (IDCs) take a long time to complete.

If you select Admin > Monitoring and view the Identity Data Unification task details, the processing times for Step 8/10: Post-Processing: Populate Role Metrics are longer than normal.

The Oracle Automatic Workload Repository (AWR) report shows long processing times for the query "BEGIN UNFC_Processor.UnifyUsers(:1 , :2 ); END;"

Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID 
      "df0mrjg1ptucs" are responsible for 100% of the database time spent on 
      the DELETE statement with SQL_ID "8h5g9538kqd9k".
      Related Object
         SQL statement with SQL_ID df0mrjg1ptucs.
         BEGIN UNFC_Processor.UnifyUsers(:1 ,:2 ); END;

Cause

This query is not optimized for changes in the way 7.0.1 does unification. 

Resolution

This issue is resolved in RSA Identity Governance and Lifecycle 7.0.1 P03.