1. Database Upgrade Guide
  2. Setting Oracle Database Parameters After a Siebel Upgrade

Setting Oracle Database Parameters After a Siebel Upgrade

Environments: Development, Test and 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 781927.1 (Article ID) on My Oracle Support. 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.