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.
For more information about generating the database performance statistics report, see the following:
How to generate Oracle database performance statistics in RSA Identity Governance & Lifecycle