Tune the Upgrade Files

1. Evaluate upgrade performance, particularly the time required to complete the upgrade.

   During a production mode upgrade, using the /z and /h parameters in the import command will reduce upgrade time and improve the overall repository import process performance.

2. Do one of the following:

   • If the time required to complete the upgrade is acceptable, no further tuning is required. Perform the steps in Process of Upgrading a Siebel Production Environment.

   • If the time required to complete the upgrade is too long, perform the remaining steps in this subtopic to continue tuning upgrade performance.

   • If the time required to complete the upgrade is too long and you cannot tune further, contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance in applying advanced tuning.

3. Carefully review target database and database server configuration. Adjust as required to further improve upgrade performance.

4. Tune the upgrade files:

   • Optimizing Unload and Load Job Performance.

   • Adding the Statistics Clause to Load Cards.

5. Copy the tuned upgrade scripts to a safe location for use in the production upgrade.