GV$BACKUP_ASYNC_IO definition in Oracle Database 11.2
GV$BACKUP_ASYNC_IO
select
inst_id, -- INST_ID NUMBER
sid, -- SID NUMBER
ser, -- SERIAL NUMBER
setid, -- USE_COUNT NUMBER
rman_status_recid, -- RMAN_STATUS_RECID NUMBER
rman_status_stamp, -- RMAN_STATUS_STAMP NUMBER
devtype, -- DEVICE_TYPE VARCHAR2(17)
decode( -- TYPE VARCHAR2(9)
type, 1, 'INPUT', 2, 'OUTPUT', 3, 'AGGREGATE', 'UNKNOWN'),
decode( -- STATUS VARCHAR2(11)
status, 1, 'NOT STARTED', 2, 'IN PROGRESS', 3, 'FINISHED', 'UNKNOWN'),
filename, -- FILENAME VARCHAR2(513)
set_count, -- SET_COUNT NUMBER
set_stamp, -- SET_STAMP NUMBER
block_size * buffer_size, -- BUFFER_SIZE NUMBER
buffer_count, -- BUFFER_COUNT NUMBER
decode( -- TOTAL_BYTES NUMBER
total_blocks, 0, null, total_blocks) * block_size,
to_date( -- OPEN_TIME DATE
open_time, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
to_date( -- CLOSE_TIME DATE
close_time, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
abs((to_date(close_time, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') - to_date(open_time, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian')) * 8640000),-- ELAPSED_TIME NUMBER
decode( -- MAXOPENFILES NUMBER
aggregate_count, 0, null, aggregate_count) * 1,
blocks * block_size, -- BYTES NUMBER
decode( -- EFFECTIVE_BYTES_PER_SECOND NUMBER
instr(open_time,close_time), 1, null, round((blocks * block_size) / abs(((to_date(close_time, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') - to_date(open_time, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian')) * 86400)))) * 1,
async_short_count + async_long_count + async_ready,-- IO_COUNT NUMBER
async_ready, -- READY NUMBER
async_short_count, -- SHORT_WAITS NUMBER
async_short_tottime, -- SHORT_WAIT_TIME_TOTAL NUMBER
async_short_maxtime, -- SHORT_WAIT_TIME_MAX NUMBER
async_long_count, -- LONG_WAITS NUMBER
async_long_tottime, -- LONG_WAIT_TIME_TOTAL NUMBER
async_long_maxtime -- LONG_WAIT_TIME_MAX NUMBER
from
x$ksfqp
where
bitand(flags,2) = 2