|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:
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:
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.|