My Oracle Support Banner

Siebel Recommendations for Tuning and Best Practices When Upgrading Database to Oracle 19c ? (Doc ID 2756174.1)

Last updated on MARCH 05, 2021

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Goal

Siebel recommendations for upgrading Database to Oracle 19c?

1. For preperation to upgrade to Database 19c, the DBA would like to set compatible mode to 11g( or current version) for a week (in case if there is a need revert back to Database 11g)
Oracle DB recommendation is to set following parameters for Oracle 19c

OPTIMIZER_FEATURES_ENABLE='19.0.0.0' ( or the version we move to )

Then turn off compatible mode.
Is this approach acceptable for Siebel?

More details on compatible mode are in the below link:
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/what-is-oracle-database-compatibility.html#GUID-A2E90F08-BC9F-4688-A9D0-4A948DD3F7A9

 

2. In the document 2077227.2 , there are recommended parameter settings for 11g and 12c.
Are there additional recommendations for 19c for OPTIMIZER_INDEX_COST_ADJ or any other parameters ?

 

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.