Backup Performance

Quest Backup Reporter

Backup Performance

The Performance tab displays performance information for current and recent backups.

A list of backup sets displays at the top of the window and includes the following information:

Type	Backup set type: Active Backup – Backup is currently active Completed Backup – Backup is complete Failed Backup – A failed backup Validate Backupset – Results of a VALIDATE BACKUPSET command
Backup Set	Backup set ID if known.
Open Time	Date and time of start of backup.
Close Time	Date and time of end of backup if known.
Elapsed Time	Elapsed time of backup if known.
Input Files	Number of input.
Input Bytes	Total size of input files.
Input Rate	Average aggregate input rate in bytes per second.
Input Ready	Percentage of reads when data was immediately available.
Input Short Waits	Percentage of reads when data was not immediately available, but data became available after a non-blocking pool for I/O.
Input Long Waits	Percentage of reads in which data did not become available until after a blocking I/O operation.
Input Sync IO	Total read time spent on synchronous I/O (if using synchronous as opposed to asynchronous I/O).
Output Files	Number of output files.
Output Bytes	Total size of output files.
Output Rate	Average aggregate output rate in bytes per second.
Output Ready	Percentage of writes when data could be immediately written.
Output Short Waits	Percentage of writes when data could not be immediately written, but was written after a non-blocking I/O operation.
Output Long Waits	Percentage of writes that resulted in a blocking I/O operation.
Output Sync IO	Total write time spent on synchronous I/O (if using synchronous as opposed to asynchronous I/O)
Empty Block Compression	Percentage of data files that did not need to be read because they did not contain active data.
Null Block Compression	Percentage of blocks read but not written because the blocks were null.
SID	Session ID of RMAN backup session
Serial	Serial number of RMAN backup session
Usage	Usage number of RMAN backup session

Note: This information primarily comes from the V$BACKUP_ASYNC_IO and V$BACKUP_SYNC_IO views. The views are volatile and clear when the data source shutdowns. This list usually includes data for all backups.

Performance details display in the lower pane and includes the following information:

Summary	Displays a high-level analysis of the performance data. The top portion of the pane displays some summary information. The lower half displays performance-related observations from the expert-system healthcheck.
Files	Displays a file-level visualization of the backup. The left side represents the input files: Notes: Each box displays a file and the file's attributes. The vertical bars display the relative percentage of Long Waits (red), Short Waits (yellow), and Ready conditions (green). You can hover over any control to display a tool tip. The right side represents the output files: Notes: NULL Block Compression refers to RMAN's ability to detect unused blocks that do not require backup. NULL Block Compression displays a data evaporating from the end of the pipe. The center section represents the flow of data through the Oracle shadow process that writes the backup:
Devices	Displays data at a device level. Notes: Cylinders represent disk devices. Cylinders with a single flow are being read or written. Cylinders with two flows are being read and written.
Raw Data	Displays data gathered from the V$BACKUP_AYSNC_IO and V$BACKUP_SYNC_IO tables. Notes: You can find column descriptions in the Oracle Reference Guide. Quest Backup Report adds the following columns: Filesize, Short Filename,, and Filesystem.

previous page start next page