The T_AV_ROLE_METRICS table is very large in RSA Identity Governance & Lifecycle
Originally Published: 2016-12-28
Article Number
Applies To
RSA Version/Condition: 6.9.1, 7.0.0, 7.0.1
Issue
In the ASR report under the Aveksa Internal Table Summary note the size of the T_AV_ROLE_METRICS table.
Aveksa Internal Table Summary:
| Table | # of Rows | Last Analyzed Date | Table Size (MB) | Index Size (MB) | # Indexes | # Valid Indexes | # Non-Valid Indexes |
|---|---|---|---|---|---|---|---|
| T_AV_ROLE_METRICS | 276766221 | 2016-10-10 20:11:16 | 36677.5 | 17862.63 | 2 | 2 | 0 |
Cause
Resolution
- RSA Identity Management Governance and Lifecycle 6.9.1 P21
- RSA Identity Governance and Lifecycle 7.0.1 P03
Related Articles
Technical/Business Owner of Application/Directory Couldn't edit Groups in SecurID Governance & Lifecycle Number of Views RSA Identity Governance and Lifecycle 7.0.1 HTML source edit doesn't work with workflow email node Number of Views RSA Via Lifecycle and Governance User Interface is inaccessible after rebooting an Appliance with the error "This page can… Number of Views Performance improvements related to T_AV_MODEL_EXPLODEDUSERENTS table in RSA Identity Governance & Lifecycle Number of Views RSA Authentication Manager 8.x services won't start when network interface adapter eth0 is not found Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) How to install the jTDS JDBC driver on WildFly for use with Data Collections in RSA Identity Governance & Lifecycle RSA Authentication Manager 8.8 Setup and Configuration Guide Artifacts to gather in RSA Identity Governance & Lifecycle
Don't see what you're looking for?
