VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using VxDBA to Perform Administrative Operations Prerelease 8 September 2005, 8:55am
370 VERITAS Storage Foundation for Oracle Administrator’s Guide
Setting the Buffer Size for Storage Rollback
This operation lets you configure the buffer size used for Storage Rollback. As with setting the
number of Storage Rollback threads, the buffer size configured for reads and writes when rolling
back an Oracle datafile can also affect performance. By default, a 128K read/write buffer is used.
Set Buffer Size for Storage Rollback displays a screen similar to the following:
This menu option lets you experiment with various settings to gain optimal performance for your
system. You do not need to change the default buffer size if the Storage Rollback performance on
your system is satisfactory. Set the buffer size in bytes—the minimum buffer size is 1K (1024
bytes), and the maximum buffer size is 1 MB (1,048,576 bytes).
---------------------------------------------------------
VxDBA: Set Buffer Size for Storage Rollback for PROD
---------------------------------------------------------
There is currently a buffer of 131072 bytes
for Storage Rollbacks associated with database PROD.
Do you want to change the buffer size? [y,n,q,?](default: y)
New size of buffer: 1024000
There is currently a buffer of 1024000 bytes
for Storage Rollbacks associated with database PROD.
Settings saved.
Press <Return> to continue...