|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 126.96.36.199 or Oracle 188.8.131.52 with the October 2017 or later Proactive Bundle Patch (BP)
|Issue||RSA Identity Governance & Lifecycle 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.|
Starting in Oracle 184.108.40.206 and the Oracle 2017 Proactive Bundle Patch (BP) for Oracle 220.127.116.11, optimizer_adaptive_features has been deprecated and replaced with two new optimizer settings:
|Tasks||These settings apply to Oracle version 18.104.22.168 or Oracle 22.214.171.124 with the October 2017 Proactive BP or later 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 RSA Identity Governance & Lifecycle Platform Datasheet and Support Matrix for your version of RSA Identity Governance & Lifecycle.
|Resolution||As user SYS, execute the following SQL to define these settings for optimal use with RSA Identity Governance & Lifecycle.|
The last parameter will take effect immediately (scope=both) but the first two will require a database restart to go into effect.
NOTE: If you are still on Oracle 126.96.36.199 with no Oracle Proactive Bundle Patches installed, then you do not have these new parameters. In this case, we require the optimizer_adaptive_features parameter be set to false as per the Database Setup and Management Guide for your RSA Identity Governance & Lifecycle version. To determine the current value for this feature:
As user SYS:
If this returns a value of TRUE, then:
The output should like this:
|Notes||If you are planning to upgrade to Oracle 19c, please see related RSA Knowledge Base Article 000039034 -- Recommended Oracle 19c Optimizer Settings for RSA Identity Governance & Lifecycle.|