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

Document created by RSA Customer Support Employee on Jan 23, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034698
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.1
IssueThe 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;"
      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;
CauseThis query is not optimized for changes in the way 7.0.1 does unification. 
ResolutionThis issue is resolved in RSA Identity Governance and Lifecycle 7.0.1 P03.