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
Account Data Collectors (ADC) fail with ORA-00904: "RESOURCE_NAME": invalid identifier after upgrading RSA Identity Govern… Number of Views 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 XudaKeyAndCertificateWriteToFile() function is very slow on Solaris Number of Views Collector circuit breaker tripped by rejections in RSA Via Lifecycle and Governance Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
