Tune the Upgrade Files
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.
Do one of the following:
If the time required to complete the upgrade is acceptable, then no further tuning is needed. Perform the steps in Restore the Production-Test Final Database.
If the time required to complete the upgrade is too long, then perform the remaining steps in this topic to continue tuning upgrade performance.
If the time required to complete the upgrade is too long and you cannot tune further, then contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle’s Application Expert Services to apply advanced tuning.
Carefully review target database and RDBMS server configuration. Adjust as needed to further improve upgrade performance.
Run Upgrade Tuner to tune the upgrade files:
UNIX. Transferring UNIX Files for Use by Siebel Upgrade Tuner.
Managing Zero-Row SQL Commands Using Siebel Upgrade Tuner.
To roll back changes you have made in previous Upgrade Tuner sessions, see Rolling Back Siebel Upgrade Tuner Changes.