V$BACKUP_SET_SUMMARY provides summary information for a backup set.
| Column | Datatype | Description |
|---|---|---|
NUM_BACKUPSETS |
NUMBER |
Total number of backup sets created |
OLDEST_BACKUP_TIME |
DATE |
Oldest backup start time |
NEWEST_BACKUP_TIME |
DATE |
Newest backup start time |
OUTPUT_BYTES |
NUMBER |
Number of output bytes (not including multiple copies) |
ORIGINAL_INPUT_BYTES |
NUMBER |
Number of input bytes when backup sets were created |
ORIGINAL_INPRATE_BYTES |
NUMBER |
Average input rate |
OUTPUT_RATE_BYTES |
NUMBER |
Average output rate |
COMPRESSION_RATIO |
NUMBER |
The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the AS COMPRESSED BACKUPSET clause of the BACKUP command. |
ORIGINAL_INPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for input bytes |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for output bytes |
ORIGINAL_INPRATE_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for input rate |
OUTPUT_RATE_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for output rate |