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
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
