GV$BACKUP_ASYNC_IO definition in Oracle Database 10.2 / www.oracledba.ru
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 NUMBER
* buffer_size,
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 -- ELAPSED_TIME NUMBER
((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),
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 -- IO_COUNT NUMBER
+ async_long_count + async_ready,
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