|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.1.1, 7.2.0
Database: Oracle 22.214.171.124 or Oracle 126.96.36.199 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. 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 188.8.131.52.
The information in this RSA Knowledge Base Article applies to those customers on Oracle 184.108.40.206 and those customers who are on 220.127.116.11 and have installed the October 2017 Proactive Bundle Patch (BP).
Please note that RSA Identity Governance & Lifecycle does not distribute Oracle 18.104.22.168 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:
|Tasks||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.
To determine the current settings for the new optimizer parameters, execute the following as user SYS:
The output should look like this:
If the output differs from the above, please follow the steps in the Resolution section to set these values as per RSA recommendations.
|Resolution||As user SYS, execute the following SQL to define these settings for optimal use with RSA Identity Governance & Lifecycle.|
If this returns a value of TRUE, then:
The output should like this: