Siebel Database Upgrade Guide > Preparing an Oracle Database for a Siebel Upgrade >

Setting Oracle Database Configuration Parameters for a Siebel Upgrade

Environments: Development, production test, production.

Databases: Oracle only.

This topic provides upgrade-specific settings for the Oracle RDBMS. Use the following strategy to set parameters:

• For information about supported Oracle Database versions and any required patches, see the Certifications tab on My Oracle Support. If required, upgrade your Oracle Database and client software to the supported version, using Oracle's tools and documented procedures.
• Set parameters using the recommendations in 781927.1 (Article ID) on My Oracle Support. (This article was previously published at Siebel Technical Note 582.)
• Set additional parameters using the recommendations in Siebel Installation Guide for the operating system you are using. Recommendations are located in the chapter on configuring the RDBMS.
• Configure the database and set parameters as indicated in the following topics.
• After the upgrade, reset the configuration parameters to the values listed in Siebel Installation Guide for the operating system you are using and in 781927.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 582.

General Configuration

Before upgrading an Oracle Database, complete the following tasks:

• Verify that your Oracle clients and Oracle Database server are at the same release level.
• UNIX only. If you have installed the Oracle 64-bit client on the Siebel Server, then verify that $ORACLE_HOME/lib32 instead of $ORACLE_HOME/lib is included in LIBPATH (AIX), SHLB_PATH (HP-UX), LD_LIBRARY_PATH (Oracle Solaris).
• pctincrease. For upgrades, compute a high enough value for pctincrease on tablespaces that contain application tables and indexes so that upgrading does not create large numbers of extents.
• pctfree. Rebuild some of your larger tables with a large value for pctfree (30 or higher). Table size depends on which Siebel Business Applications you have installed. For example, if you are upgrading Siebel Financial Services, S_ASSET is a large table and S_ADDR_ORG is not used at all.

  You must increase pctfree before the upgrade because many new columns are added to tables during the upgrade. Migrating data into the new columns during the upgrade is likely to cause row chaining, which degrades upgrade performance.

• DB_CACHE_SIZE. Set this parameter to a minimum of 394264576.
• SORT_AREA_SIZE. Set this parameter to a minimum of 1524288. This significantly reduces the time required to complete a repository merge.

  See Siebel Performance Tuning Guide for other parameter settings.

• UNDO_MANAGEMENT (Oracle Database 10g and later). Set the UNDO_MANAGEMENT parameter to MANUAL before the repository merge. This turns off Automatic Undo Management (AUM). You can turn AUM back on after the repository merge, as desired. For more information on how AUM affects upgrade, see 477025.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Alert 848.
• Rollback Segments. Verify that you have only one large rollback segment on line that is appropriately sized so that the largest of transactions can be accommodated. Take all other rollback segments off line.

  The upgrade might affect some of the largest tables in your implementation of Siebel CRM version 7.x, causing them to grow by as much as 40%.

  Customer experience has shown that repository merges involving multiple languages can require a rollback segment as large as 1 GB.

Query Optimizer Settings

For the upgrade, use the query optimizer settings listed in 781927.1 (Article ID) My Oracle Support. This document was previously published as Siebel Technical Note 582 and Siebel Alert 1011.