Recommended Value for Optimizer_Index_Cost_ADJ parameter in Integrated instance
(Doc ID 1497691.1)
Last updated on JUNE 07, 2021
Applies to:Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document