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

Originally Published: 2017-01-17

Last Modified: 2022-06-20

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.

Don't see what you're looking for?

Related Articles

Trending Articles