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.
Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.