VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 13, Using the VxDBA Utility
Prerelease 8 September 2005, 8:55am Using VxDBA to Perform Administrative Operations
369
Setting the Number of Storage Rollback Threads
This operation lets you configure the number of threads used when rolling back an Oracle datafile.
Performance is a critical factor when rolling a file back to a Storage Checkpoint. By default, 8
lightweight threads are used to partition up and recover a datafile. Depending on the number of
CPUs available on your system and the type of volume on which the file system is located, this
default setting may specify too few or too many threads.
Set Number of Storage Rollback Threads displays a screen similar to the following:
This menu option lets you experiment with various settings to achieve optimal performance for
your system. You do not need to change the default number of threads if the Storage Rollback
performance on your system is satisfactory. The maximum number of threads you can set is 63, and
the minimum number of threads is 1.
----------------------------------------------------------
VxDBA: Set Number of Storage Rollback Threads for PROD
----------------------------------------------------------
There are currently 8 threads set for
Storage Rollbacks associated with database PROD.
Do you want to change the number of parallel threads?
[y,n,q,?](default: y)
New number of threads: 16
Settings saved.
Press <Return> to continue...