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 |
Compression ratio |
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 |