1. Database Upgrade Guide
  2. About Tuning Siebel Production Upgrade Files

About Tuning Siebel Production Upgrade Files

Environments: Test environment only. Does not apply to production environment.

Platforms: Windows and UNIX only.

The Upgrade Tuner allows you to tune the upgrade files generated by the Siebel Database Configuration Utilities. Tuning the production upgrep files can significantly reduce database downtime when performing a production environment upgrade.

Upgrade Tuner displays the following information and provides the following options:

  • Table creation times. You can place tables with long creation times in parallel threads.

  • Index creation times. You can assign index creation to run in parallel threads.

  • Zero-Row SQL commands. You can review and inactivate SQL statements that do not affect any table rows.

The scripts used to upgrade your Siebel database are generic. They update your Siebel database to support all Siebel Business Applications functionality. You can use this option to eliminate SQL statements that are not needed for your applications.