Siebel Database Upgrade Guide > Postupgrade Tasks for the Siebel Database and File System >
Setting Oracle Database Parameters After a Siebel Upgrade
Upgrades from: All Supported Siebel releases.
Environments: Development, production test, production.
Databases: Oracle only.
After the Siebel Database upgrade is complete, set the following parameters in init.ora:
- optimizer_index_cost_adj. Set this parameter to 1.
- Collecting statistics. To optimize SQL performance, use the PL/SQL package dbms_stats to manage statistics gathering. For additional information on optimizer settings, see Bulletin 478028.1 (Doc ID) on OracleMetalink 3. This document was previously published as Siebel Technical Note 582.
- For a full list of recommended settings for your postupgrade production environment, see the chapter on configuring the RDBMS in Siebel Installation Guide for the operating system you are using.