Bookshelf Home | Contents | Index | PDF |
Upgrade Guide > Preparing an Oracle Database for a Siebel Upgrade > Setting Oracle Database Optimizer Mode for a Siebel UpgradeUpgrades: All Siebel upgrades. Environments: Development, production test, production. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. Oracle 9iYou can run the development upgrade, production test upgrade, and the production upgrade in either Rule Based Optimizer (RBO) mode or in Cost Based Optimizer (CBO) mode. You need not run all environment upgrades in the same mode. For example, you can run the development environment upgrade in RBO mode and the production test environment upgrade in CBO mode. Oracle 10gRun all environment upgrades in CBO mode. Setting the Optimizer ModeSet the optimizer mode (OPTIMIZER_MODE) in init.ora as follows: Do not use the other OPTIMIZER_MODE settings. Related Topics |
Upgrade Guide | Copyright © 2006, Oracle. All rights reserved. | |