Article Number
000036774
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
Issue
Overall system performance is slow, especially navigating the user interface and user sessions are timing out when accessing new pages.
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
This is a known issue reported in engineering ticket ACM-85934.
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
The disk space needs to be managed. Options available such as Data Purging and Data Archiving depend on your version of RSA Identity Governance & Lifecycle. See RSA Knowledge Base Article
000038168 -- How to manage database growth in RSA Identity Governance & Lifecycle to find the best solution for your environment.
Workaround
If you are on RSA Identity Governance & Lifecycle 7.1.0 P04 or higher, there is a workaround available. Please contact
RSA Identity Governance & Lifecycle Customer Support for the workaround and mention this RSA Knowledge Base Article ID 000036774 for reference.
