• optimizer_adaptive_plans
• optimizer_adaptive_statistics
• cursor_sharing
• optimizer_index_cost_adj
• optimizer_index_caching

• optimizer_features_enable
• compatible

• For Oracle 12.1.0.2 (2017 or later Proactive Bundle Patches not installed ) and below, see the RSA Identity Governance & Lifecycle Database Setup and Management Guide.
• For Oracle 12.2.0.1 and Oracle 12.1.0.2 (2017 or later Proactive Bundle Patches installed) see RSA Knowledge Base Article 000038082 -- Recommended Oracle 12.2.0.1 or 12.1.0.2 Proactive Bundle Patch October 2017 or later Optimizer Settings in RSA Identity Governance & Lifecycle.
• RSA Identity Governance & Lifecycle does not distribute Oracle 19c. Therefore, if you are on an RSA-Supplied database, this article does not apply to your environment.
• Although Oracle 19c is supported for use with RSA Identity Governance & Lifecycle, it has not been qualified (certified) for use with RSA Identity Governance & Lifecycle 7.1.1 or 7.2.0.
• This RSA Knowledge Base Article is specific to Oracle 19c and not 12.2.0.2 (Oracle 18c).

select * from product_component_version;

alter system set optimizer_adaptive_plans=FALSE scope=spfile sid='*';
alter system set optimizer_adaptive_statistics=FALSE scope=spfile sid='*';
alter system set optimizer_index_cost_adj=30 scope=both sid='*';
alter system set optimizer_index_caching=50 scope=both sid='*';
alter system set cursor_sharing=force scope=spfile sid='*';
alter system reset optimizer_features_enable scope=spfile sid='*';
alter system reset compatible scope=spfile sid='*';

• The recommended Oracle 12.2.0.1 optimizer_features_enable parameter and the compatible parameter (if set) need to be reset to their default values.
• Parameter settings with scope=both will take effect immediately. All other parameters require a database restart to go into effect.