Users tab slow to load in SecurID Governance & Lifecycle
Article Number
Applies To
This is a known issue in the following versions when using Oracle 19c as the datastore:
- RSA Governance & Lifecycle 7.2.1
- RSA Governance & Lifecycle 7.5.0
- SecurID Governance & Lifecycle 7.5.2
Issue
The Users page under the Users menu is slow to load.
The following query shows in the AWR report as being executed for a very large number of times:
| gnf27z7h9fvd1 | SELECT MAX(LAST_NAME || ', ' || FIRST_NAME) FROM T_MASTER_ENTERPRISE_USERS WHERE ID = :B1 |
Cause
Resolution
This issue is resolved in the following versions:
- RSA Governance & Lifecycle 7.5.0 P08
- SecurID Governance & Lifecycle 7.5.2 P04
Related Articles
Accessing the raw data tabs for collector runs is very slow in RSA Identity Governance & Lifecycle Number of Views Access Manager servers are slow to start up. Number of Views Error "ORA-00001: unique constraint (AVUSER.PK_T_DATA_RUNS) violated" after restoring from backup in RSA Governance & Life… Number of Views How users are selected for reviews that are triggered by rules in RSA Identity Governance & Lifecycle Number of Views Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle Number of Views
Don't see what you're looking for?
