DBA Data[Home] [Help]

VIEW: SYS.GV_$BACKUP_ASYNC_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","READY","SHORT_WAITS","SHORT_WAIT_TIME_TOTAL","SHORT_WAIT_TIME_MAX","LONG_WAITS","LONG_WAIT_TIME_TOTAL","LONG_WAIT_TIME_MAX","CON_ID" from gv$backup_async_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"
, "READY"
, "SHORT_WAITS"
, "SHORT_WAIT_TIME_TOTAL"
, "SHORT_WAIT_TIME_MAX"
, "LONG_WAITS"
, "LONG_WAIT_TIME_TOTAL"
, "LONG_WAIT_TIME_MAX"
, "CON_ID"
FROM GV$BACKUP_ASYNC_IO