Bookshelf Home | Contents | Index | PDF |
Upgrade Guide > Tuning the Siebel Upgrade Files > Managing Parallel Threads Using Siebel Upgrade TunerUpgrades: All Siebel upgrades. Environments: Production test environment only. Does not apply to production environment. Platforms: Windows and UNIX only. Upgrade Tuner allows you to create, edit, and delete parallel thread for table and index creation. This improves upgrade performance by reducing the amount of time required to complete table and index creation. You create, edit, and delete threads in the Parallelize Table Creation page and the Parallelize Index Creation page. These two pages have the same layout. Related TopicsPrerequisites
Displaying ThreadsYou can view and sort the contents of threads or view items sorted across threads:
Creating Parallel ThreadsUse this procedure to create a parallel thread for table creation or index creation. Upgrade Tuner automatically names threads Parallel Thread 1, Parallel Thread 2, and so on. You cannot edit thread names. You start creating parallel threads by creating Parallel Thread 1 and Parallel Thread 2 together. You must assign at least one table or index to each of these threads. All threads you create must contain at least one table or index. To create Parallel Thread 1 and Parallel Thread 2
To create additional parallel threads
TIP: Another way to create a new thread is to right-click in a row. In the drop-down menu, select the last thread listed. Moving Items Between ThreadsUse the left and right arrow keys to move tables or indexes between threads, including the Serial Thread. NOTE: You cannot save and exit if any thread is empty. Deleting a ThreadUse this procedure to delete an existing thread. You cannot delete the Serial Thread. You must delete Parallel Thread 1 and Parallel Thread 2 together. You must delete all other threads before deleting Parallel Thread 1 and Parallel Thread 2. To delete a thread other than Parallel Thread 1 or Parallel Thread 2
To delete Parallel Thread 1 and Parallel Thread 2
Evaluating Upgrade Performance ImprovementTo evaluate production upgrep performance improvement, use the two fields at the top of the page:
The difference between the sequential creation time and the parallelized creation time is an estimate of the reduction in upgrade time from using parallel threads. You can reduce upgrade time further by performing the following actions:
The goal is to reduce both the Serial Thread time and longest-running parallel thread time to a minimum. Because each new parallel thread requires additional memory and CPU cycles, you may need to experiment with the number of parallel threads to optimize upgrade performance. |
Upgrade Guide | Copyright © 2006, Oracle. All rights reserved. | |