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
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 Adding a new user attribute in a user profile in RSA Authentication Manager 8.x 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 Supervisor does not update for new users in RSA Identity Governance & Lifecycle Number of Views When replacing an RSA SecurID software token with a new software token the token PIN is not carried over to the new token Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) Artifacts to gather in RSA Identity Governance & Lifecycle RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
