Overall slow performance navigating the user interface and user sessions are timing out when displaying new pages in RSA Identity Governance & Lifecycle
Originally Published: 2018-09-25
Article Number
Applies To
RSA Version/Condition: All
Issue
The Oracle AWR shows a lot of long-running SQL queries similar to the following:
SELECT COUNT(*) AS NUM_ROWS FROM ...For more information on the Oracle AWR, see RSA Knowledge Base Article 000037779 - How to generate an Oracle Automatic Workload Repository (AWR) report for RSA Identity Governance & Lifecycle.
Cause
The queries that look like this:
SELECT COUNT(*) AS NUM_ROWS FROM ....
are used to gather counts displayed in the user interface. We have seen this issue when a system is undersized with huge amounts of data and many users logging into the system concurrently.
Resolution
Workaround
Related Articles
Users are not assigned to new RSA Identity Management and Governance and Lifecycle business unit after collection Number of Views RSA Authentication Agent 7.x for Web for Apache on Red Hat 5 throws error 103: Response to New PIN Request took too long e… Number of Views Roles get stuck in the Applied or Applied New State and cannot be modified in RSA Identity Governance & Lifecycle Number of Views Adding a new user attribute in a user profile in RSA Authentication Manager 8.x Number of Views Cannot add or manage a user with user ID <UserID>. User IDs must be unique within a deployment. This user ID is already in… Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
