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
Every application restart loses the customerstrings.properties file in versions 7.0.2 and 7.1.0 of RSA Identity Governance… 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 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 Apply error 'ORA-01403: no data found' occurring on all clusters every 15 minutes Number of Views NT: PIN on token has to be reset every ten minutes Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
