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 I1912 - The SEL is full of events and is unable to log any more 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 java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got NCLOB in RSA Identity Governance & Lif… 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
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?
