RSA Identity Governance & Lifecycle Support will often request an AWR report from customers to assist with troubleshooting product issues, when customer-supplied database is being used and the customer has the appropriate licensing to generate AWR. The right to use AWR is part of the Oracle Diagnostics Pack. Customers should contact their DBA team to find out whether they are licensed to run AWR reports.
If a customer has the appropriate Oracle licensing to generate AWR reports for their customer-supplied database, the Diagnostics feature must be enabled in the Oracle database to be able to generate an AWR report. This can be verified by running the following SQL statement:
oracle@acm-710:~> sqlplus / as sysdba
SQL*Plus: Release 220.127.116.11.0 Production on Tue Feb 26 14:02:44 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS;
NAME TYPE VALUE
------------------------------------ ------------- -------------------
control_management_pack_access string DIAGNOSTIC
Seeing the value of DIAGNOSTIC in the above SQL query indicates that the Oracle Diagnostics Pack is enabled (subject to the customer having the required Oracle license) to run AWR reports in a customer-supplied database scenario.
RSA Identity Governance & Lifecycle provides the ability to generate a database performance statistics report, an alternative to AWR, for troubleshooting database performance issues.
Customers using an RSA-provided database for RSA Identity Governance & Lifecycle must generate a database performance statistics report for troubleshooting database performance issues. RSA Identity Governance & Lifecycle versions 7.1.1 P11, 7.2.0 P07, 7.2.1 P02, and all older versions, may have the Oracle parameter 'control_management_pack_access' set to DIAGNOSTIC. This Oracle parameter will be reset to NONE for RSA-provided database, effective 7.1.1 P12, 7.2.0 P08, 7.2.1 P03, and in future versions of RSA Identity Governance & Lifecycle.