Upgrade Guide > Postupgrade Tasks for the Siebel Database and File System >

Setting Oracle Database Parameters After a Siebel Upgrade

Upgrades: All Siebel upgrades.

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 Technical Note 582 on Oracle's Siebel SupportWeb.
• (Oracle 9i only) optimizer_max_permutations. Set this parameter to 100. This parameter is obsolete on Oracle 10g and later.
• 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.