Recommended Value for Optimizer_Index_Cost_ADJ parameter in Integrated instance
(Doc ID 1497691.1)
Last updated on MARCH 06, 2023
Applies to:
Oracle Demantra Demand Management - Version 7.3.1 and laterInformation in this document applies to any platform.
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
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
Goal |
Solution |