My Oracle Support Banner

Can We Use 11g Optimizer Plan For Siebel IP19 Application With Oracle 12c DB (Doc ID 2560591.1)

Last updated on JULY 01, 2019

Applies to:

Siebel CRM - Version 19.3 and later
Information in this document applies to any platform.

Goal

1. Can we use siebel application IP19 with 11g optimizer plan[Optimizer_feature_enabled]. Will it support ?
Will there any impact or performance issue with ip19 and 11g optimizer plan ?
 
2:Database  version is 12.1.0.2
In our environment SPM is used. Will perform RAT.
In this scenario what should be the parameter optimizer_adaptive_features and optimizer_features_enable.
 
3:optimizer_adaptive_features = true
optimizer_features_enable = 12.1.0.2

If we set the above 2 parameters,does it have any variation in the setting of below parameter values as per Siebel.
Please suggest the values for below database parameters for Siebel in our scenario.
OPTIMIZER_ADAPTIVE_REPORTING_ONLY
OPTIMIZER_INDEX_CACHING
OPTIMIZER_MODE
QUERY_REWRITE_INTEGRITY
STAR_TRANSFORMATION_ENABLED
OPTIMIZER_INDEX_COST_ADJ
OPTIMIZER_DYNAMIC_SAMPLING
DB_FILE_MULTIBLOCK_READ_COUNT
QUERY_REWRITE_ENABLED
_B_TREE_BITMAP_PLANS
_PARTITION_VIEW_ENABLED
_NO_OR_EXPANSION
_OPTIMIZER_MAX_PERMUTATIONS
_LIKE_WITH_BIND_AS_EQUALITY
SESSION_MAX_OPEN_FILES
FILESYSTEMIO_OPTIONS
 

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
References


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