RSA Identity Governance and Lifecycle Account Data Collector (ADC) and Entitlement Data Collectors (EDC) are slow in step Calculate Role Metrics of the Indirect Relationship Processing task
Originally Published: 2017-08-11
Article Number
Applies To
RSA Version/Condition: 7.0.1, 7.0.2
Issue
An Oracle Automatic Workload Repository (AWR) report shows the following two queries as consuming most of the time.
INSERT INTO GTT_ROLECONSTRAINT_USERS (ID) SELECT ID FROM T_MASTER_ENTERPRISE_USERS USERS WHERE DELETION_DATE IS NULL AND ...
BEGIN Common_Exploder.Process(:1 , :2 ); END;
Cause
Resolution
In the Database Performance Statistics section, inspect the column for Last Analyzed Date for the table T_AV_USER_ACCOUNT_MAPPINGS. If the date is absent or old, then force statistics to be collected on this table.
To force database statistics on this table, in SQL*Plus or using Oracle SQL Developer, run the following SQL command.
EXEC DATABASE_STATISTICS.GATHER_TABLE('T_AV_USER_ACCOUNT_MAPPINGS');Notes
Related Articles
Collections are slow in Indirect Relationship Processing step in RSA Identity Governance & Lifecycle Number of Views Identity Data Collector (IDC) collection fails with the error: "ORA-00918: column ambiguously defined" during the Identit… Number of Views Identity Data Unification longer in Step 8/11 Populate Role Metrics in RSA Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle 7.2 Platform Datasheet and Support Matrix Number of Views How to determine who has created an RSA Identity Governance and Lifecycle Account Data Collector (ADC) Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?
