Recommended Value for Optimizer_Index_Cost_ADJ parameter in Integrated instance
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***
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?
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