My Oracle Support Banner

Required Database Parameters In 12.1.0.2 For Siebel Application IP19 (Doc ID 2563196.1)

Last updated on JANUARY 25, 2020

Applies to:

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

Goal

1. Our database is being upgraded from 11.2.0.4 to 12.1.0.2.Need exact values in setting the optimizer, in memory and other db parameters related to memory which are affecting performance for Siebel performance?
 
2.1) Is optimizer_features_enable=11.2.0.4,optimizer_adaptive_features=FALSE set in database version 12.1.0.2 compatible with Siebel IP19?
If NO=
1.1) If it is not compatible, we will have to test the Siebel application IP13 with 12.1.0.2 optimizer by doing RAT with SPM enabled. Then will have to set optimizer_features_enableIf YES=
1.2) If it is compatible, then we can have the Siebel IP13 work as usual with 12.1.0.2 Upgraded DB having 11.2.0.4 optimizer features for now. After Siebel upgrade to IP19 then enable the optimizer adaptive features and set optimizer_features_enable=12.1.0.x ?
 

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.