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

Last updated on SEPTEMBER 09, 2022

Applies to:

Goal

1. Can we use siebel 19 application with 11g optimizer plan[Optimizer_feature_enabled]. Will it support ?
Will there any impact or performance issue with Siebel 19 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

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