Oracle Database
The following guidelines and requirements are for planning your upgrade on Oracle Database.
If you upgrade the Siebel database and then upgrade the Oracle RDBMS, then you must validate the Siebel database schema after the upgrade. See Verifying an Upgraded Oracle Database After a Siebel Upgrade.
Development, test, and production upgrades on Oracle Database 11g, can be run in CBO mode.
If you plan to upgrade your Oracle Database, then see 781927.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 582. This document provides information on setting up Oracle Database for use with Oracle Cost-based optimizer (CBO) and on doing other performance tuning for Oracle Database. Using Oracle’s Cost Based Optimization with a Siebel database entails certain requirements for database parameter configuration and for the Optimizer’s statistics generation on tables, columns and indexes.