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
RSA Via Lifecycle and Governance User Interface is inaccessible after rebooting an Appliance with the error "This page can… Number of Views Technical/Business Owner of Application/Directory Couldn't edit Groups in SecurID Governance & Lifecycle Number of Views Performance improvements related to T_AV_MODEL_EXPLODEDUSERENTS table in RSA Identity 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 Error when trying to add duplicate user attribute: "Can't be mapped more than once as User Attribute!" in RSA Via Lifecycl… Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
