My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.