Evaluating Upgrade Performance Improvement
To evaluate production upgrep performance improvement, use the two fields at the start of the page:
Total cost of sequential table (or index) creation. Displays the time to create tables or indexes when no parallel threads are used.
Total cost of parallelized table (or index) creation. Displays the time to complete the upgrade using the parallel threads you have created. The time is computed by adding the Serial Thread time and the longest-running parallel thread time.
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:
Move additional items from the Serial Thread to a parallel thread
Move items from the longest-running parallel thread to other threads or a new thread
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 might need to experiment with the number of parallel threads to optimize upgrade performance.