Recommended Value for Optimizer_Index_Cost_ADJ parameter in Integrated instance (Doc ID 1497691.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Mar-2017***

Goal

Customer has the following question for an integrated instance

Demantra and ASCP are in the same 11g database instance. Currently Optimizer_Index_Cost_ADJ parameter is default 100. Demantra recommend to set it between 25 and 50. We know this would change all the SQL plan in the database, including ASCP. In this case, what's your recommendation for this parameter?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms