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
Indirect Relationship Processing slower in Step 11/12 Calculate Role Metrics in RSA 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 Collections are slow in Indirect Relationship Processing step in RSA Identity Governance & Lifecycle Number of Views Data Archiving fails in Data Purging step in RSA Identity Governance & Lifecycle Number of Views Identity Data Unification longer in Step 8/11 Populate Role Metrics in RSA Governance & Lifecycle Number of Views
Trending Articles
RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to Upgrade Internal SHA-1 Certificates to SHA-256 in Authentication Manager Using rsautil RSA Authentication Manager 8.9 Setup and Configuration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device
Don't see what you're looking for?
