How to generate Oracle database performance statistics in RSA Governance & Lifecycle
a year ago
Article Number
000072966
Applies To

RSA Identity Governance & Lifecycle 7.2.1 (and later)

Resolution

At times, you may need to gather additional information to troubleshoot database performance issues in RSA Governance & Lifecycle. Oracle Automatic Workload Repository (AWR) report typically provides information around database performance issues. Generating an AWR report requires appropriate Oracle licensing; refer to Oracle documentation for further details. An alternative to AWR is to generate the Oracle database performance statistics from the RSA Governance & Lifecycle UI. For RSA Identity Governance & Lifecycle 7.2.1 (and later), the option to generate database performance statistics is available on the UI > Admin > Diagnostics > General tab > Start DB Logging.

StartDBLogging-7.2.1.jpg

Refer to the following video for more details on how to generate the database performance statistics report in RSA Governance & Lifecycle for troubleshooting purpose: