Database Statistics running after every collection in RSA Identity Governance & Lifecycle
Originally Published: 2021-11-08
Article Number
Applies To
RSA Version/Condition: 7.2.1, 7.5.0
Issue
- Database Statistics against T_AV_EXPLODEDUSERENTITLEMENTS table are running after every collection in RSA Identity Governance & Lifecycle.
- Collections are slow in Step 11/12 Relationship Processing: Update Statistics.
- AWR reports show a query similar to the following running for a long time:
/* SQL Analyze(0) */ select /*+ full(t) parallel(t, 5) parallel_index(t, 5) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false') no_substrb_pad */to_char(count("ID")), substrb(dump(min("ID"), 16, 0, 64), 1, 240), substrb(dump(max("ID"), 16, 0, 64), 1, 240), to_char(count("RUN_ID")), substrb(dump(min("RUN_ID"), 16, 0, 64), 1, 240), substrb(dump(max("RUN_ID"), 16, 0, 64), 1, 240), to_char(count("DC_ID")), substrb(dump(min("DC_ID"), 16, 0, 64), 1, 240), substrb(dump(max("DC_ID"), 16, 0, 64), 1, 240), to_char(count("APPLICATION_ID")), substrb(dump(min("APPLICATION_ID"), 16, 0, 64), 1, 240), substrb(dump(max("APPLICATION_ID"), 16, 0, 64), ETC....Cause
This issue may occur on systems where the T_AV_EXPLODEDUSERENTITLEMENTS table is very large. Normally database statistics is run on this table after each collection. In some instances, the cost of this run may be more than the benefit.
Resolution
- RSA Identity Governance & Lifecycle 7.2.1 P04
- RSA Identity Governance & Lifecycle 7.5.0
After patching to the version where this is resolved, set the following parameter from Admin > System > Settings > Custom section. When this parameter is set, the Database Statistics will only run on the T_AV_EXPLODEDUSERENTITLEMENTS table if more than 5% of the table has changed.
| Parameter | Value |
| CollectorStatsConditional | True |
Related Articles
I1912 - The SEL is full of events and is unable to log any more Number of Views Every application restart loses the customerstrings.properties file in versions 7.0.2 and 7.1.0 of RSA Identity Governance… Number of Views RSA Announces RSA Authentication Manager 8.4 Patch 4 with New Features Making It Easier Than Ever to Adopt Modern MFA Auth… Number of Views 'AFX server is not running' message printed in logs every minute for each unused (Disabled, Not running, or deleted) AFX S… Number of Views java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got NCLOB in RSA Identity Governance & Lif… Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
