RSA Identity Governance and Lifecycle IDC Unification is slow in "Step 8/10: Post-Processing: Populate Role Metrics" after upgrading to 7.0.1
4 years ago
Originally Published: 2017-01-17
Article Number
000040143
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.