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 Adding a new user attribute in a user profile in RSA Authentication Manager 8.x 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 Migrating an RSA Authentication Manager 8.x deployment to a new location with different network settings Number of Views Coming Soon: SecurID Authenticator 6.0 for Windows Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager 8.9 Release Notes (January 2026) Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA SecurID Software Token 5.0.2 for Windows Desktop displays message after reboot due to roaming profile: No token stor…
Don't see what you're looking for?
