DBA Data[Home] [Help]

VIEW: SYS.V_$BACKUP_SET_SUMMARY

Source

View Text - Preformatted

select "NUM_BACKUPSETS","OLDEST_BACKUP_TIME","NEWEST_BACKUP_TIME","OUTPUT_BYTES","ORIGINAL_INPUT_BYTES","ORIGINAL_INPRATE_BYTES","OUTPUT_RATE_BYTES","COMPRESSION_RATIO","ORIGINAL_INPUT_BYTES_DISPLAY","OUTPUT_BYTES_DISPLAY","ORIGINAL_INPRATE_BYTES_DISPLAY","OUTPUT_RATE_BYTES_DISPLAY","CON_ID" from v$backup_set_summary
View Text - HTML Formatted

SELECT "NUM_BACKUPSETS"
, "OLDEST_BACKUP_TIME"
, "NEWEST_BACKUP_TIME"
, "OUTPUT_BYTES"
, "ORIGINAL_INPUT_BYTES"
, "ORIGINAL_INPRATE_BYTES"
, "OUTPUT_RATE_BYTES"
, "COMPRESSION_RATIO"
, "ORIGINAL_INPUT_BYTES_DISPLAY"
, "OUTPUT_BYTES_DISPLAY"
, "ORIGINAL_INPRATE_BYTES_DISPLAY"
, "OUTPUT_RATE_BYTES_DISPLAY"
, "CON_ID"
FROM V$BACKUP_SET_SUMMARY