|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.1.1
Database: Oracle 126.96.36.199 or Oracle 188.8.131.52 with the October 2017 or later Proactive Bundle Patch (BP)
|Issue||The RSA Identity Governance & Lifecycle product requires certain optimizer settings be set in the Oracle database for optimal query performance. These optimizer settings are documented in the RSA Identity Governance & Lifecycle Database Setup and Management Guide. Please click here for access to the Database Setup and Management Guide for your RSA Identity Governance & Lifecycle version. One of these required settings is optimizer_adaptive_features, a setting RSA Identity Governance & Lifecycle requires be disabled.|
Oracle 12.2 has introduced two new optimizer settings that replace the optimizer_adaptive_features parameter. In addition, Oracle has bundled these new parameters into their Oracle 2017 Proactive Bundle Patch (PB) for Oracle 184.108.40.206.
The information in this RSA Knowledge Base Article applies to those customers on Oracle 220.127.116.11 and those customers who are on 18.104.22.168 and have installed the October 2017 Proactive Bundle Patch (BP).
Please note that RSA Identity Governance & Lifecycle does not distribute Oracle 22.214.171.124 nor does it distribute Oracle Proactive BPs as part of the Appliance Updater. The Appliance Updater has Oracle Critical Patch Updates (CPUs) and Patch Set Updates (PSUs) only. Therefore, if you are on an RSA Supplied database, you will not have these settings and this article does not apply to your environment.
The new optimizer settings are:
These settings apply to Oracle version 12.2 or Oracle 12.1 with the October 2017 Proactive BP installed. To validate the database version that you are on, as AVUSER, run the following SQL query.
The output will look similar to the following:
For more information on supported database versions, please see the product matrix for your version.
|Resolution||As user SYS, execute the following SQL to define these settings for optimal use with RSA Identity Governance & Lifecycle.|