DBA Data[Home] [Help]

VIEW: SYS.V_$BACKUP_DATAFILE_SUMMARY

Source

View Text - Preformatted

select "NUM_FILES_BACKED","NUM_DISTINCT_FILES_BACKED","NUM_DISTINCT_TS_BACKED","MIN_CHECKPOINT_CHANGE#","MAX_CHECKPOINT_CHANGE#","MIN_CHECKPOINT_TIME","MAX_CHECKPOINT_TIME","INPUT_BYTES","OUTPUT_BYTES","COMPRESSION_RATIO","INPUT_BYTES_DISPLAY","OUTPUT_BYTES_DISPLAY","CON_ID" from v$backup_datafile_summary
View Text - HTML Formatted

SELECT "NUM_FILES_BACKED"
, "NUM_DISTINCT_FILES_BACKED"
, "NUM_DISTINCT_TS_BACKED"
, "MIN_CHECKPOINT_CHANGE#"
, "MAX_CHECKPOINT_CHANGE#"
, "MIN_CHECKPOINT_TIME"
, "MAX_CHECKPOINT_TIME"
, "INPUT_BYTES"
, "OUTPUT_BYTES"
, "COMPRESSION_RATIO"
, "INPUT_BYTES_DISPLAY"
, "OUTPUT_BYTES_DISPLAY"
, "CON_ID"
FROM V$BACKUP_DATAFILE_SUMMARY