DBA Data[Home] [Help]

VIEW: SYS.GV_$BACKUP_SYNC_IO

Source

View Text - Preformatted

select "INST_ID","SID","SERIAL","USE_COUNT","RMAN_STATUS_RECID","RMAN_STATUS_STAMP","DEVICE_TYPE","TYPE","STATUS","FILENAME","SET_COUNT","SET_STAMP","BUFFER_SIZE","BUFFER_COUNT","TOTAL_BYTES","OPEN_TIME","CLOSE_TIME","ELAPSED_TIME","MAXOPENFILES","BYTES","EFFECTIVE_BYTES_PER_SECOND","IO_COUNT","IO_TIME_TOTAL","IO_TIME_MAX","DISCRETE_BYTES_PER_SECOND","CON_ID" from gv$backup_sync_io
View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "SERIAL"
, "USE_COUNT"
, "RMAN_STATUS_RECID"
, "RMAN_STATUS_STAMP"
, "DEVICE_TYPE"
, "TYPE"
, "STATUS"
, "FILENAME"
, "SET_COUNT"
, "SET_STAMP"
, "BUFFER_SIZE"
, "BUFFER_COUNT"
, "TOTAL_BYTES"
, "OPEN_TIME"
, "CLOSE_TIME"
, "ELAPSED_TIME"
, "MAXOPENFILES"
, "BYTES"
, "EFFECTIVE_BYTES_PER_SECOND"
, "IO_COUNT"
, "IO_TIME_TOTAL"
, "IO_TIME_MAX"
, "DISCRETE_BYTES_PER_SECOND"
, "CON_ID"
FROM GV$BACKUP_SYNC_IO