First page Back Continue Last page Graphics
Tuning Tools
V$BACKUP_SYNC_IO
- Synchronous I/O statistics
V$BACKUP_ASYNC_IO
- Asynchronous I/O statistics
runstats.sql
- Derived from a Tom Kyte script
- Uses V$MYSTAT
- Stats for the current session
V$SESSION_LONGOPS
V$SESSION_WAIT
- Determine why job is hanging or slow
Notes:
I will present several test cases in this lesson. The tools we will use to capture RMAN runtime statistics are:
V$BACKUP_SYNC_IO – This view contains statistics on “ongoing and recently completed” RMAN synchronous I/O operations. We will see that we actually do not want to see statistics here because we will prefer asynchronous I/O. So we will just query this view to insure there is nothing here – confirming that we are using asynchronous I/O.
V$BACKUP_ASYNC_IO - This view contains statistics on “ongoing and recently completed” RMAN asynchronous I/O operations.
runstats.sql – This script (supplied with the course book) is derived from a Tom Kyte script (see http://asktom.oracle.com). This script uses V$MYSTAT to measure the total overall elapsed time for the RMAN job.
Refer to the Oracle9i Database Reference manual for detailed information on these V$ views.