|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.2.0
Database: Oracle 19c
|Issue||RSA Identity Governance & Lifecycle requires certain optimizer settings be set in the Oracle database for optimal query performance. The required optimizer settings differ per Oracle database version. The purpose of this RSA Knowledge Base Article is to explain how to configure the Oracle optimizer settings for Oracle 19c to assist the Oracle 19c optimizer in choosing an optimal SQL execution plan and prevent performance degradation due to a poorly constructed execution plan. The database parameters that need to be set in Oracle 19c are:|
|Tasks||These settings apply to Oracle version 19c. To validate the database version that you are on, as avuser, run the following SQL query.|
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.|