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