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
Adding a new user attribute in a user profile in RSA Authentication Manager 8.x Number of Views An extra group that's non-existed in the role added while trying to add new user to the role in RSA Governance & Lifecycle Number of Views Adding a new Fortinet RADIUS dictionary to RSA RADIUS for RSA Authentication Manager Number of Views Role Stuck in 'Applied' or 'Applied New' State with 'Additional Changes Cannot Be Made' error in RSA Governance & Lifecycle Number of Views WFLYCTL0344 Operation timed out awaiting service container stability error when patching RSA Identity Governance & Lifecycle Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
