First page Back Continue Last page Graphics

Parallelism Test…


Notes:

This test invokes a backup to two disk devices using two channels. I execute the routines “RS_START” and “RS_STOP” to capture performance statistics (see the statistics on the following page). These scripts are derived from a script I found on the Tom Kyte web site, http://asktom.oracle.com/~tkyte/runstats.html. The scripts are provided with this course book.
To run similar tests on your server, review, modify where necessary and execute the following supplied script and log files:
more_channels_than_disks.sql
two_channels.rman
ten_channels.rman
two_channels.log
ten_channels.log
The scripts required to capture and display elapsed time are:
runstats.sql
display_elapsed_time.sql