select
  SID,                                     -- SID NUMBER
  SERIAL,                                  -- SERIAL NUMBER
  USE_COUNT,                               -- USE_COUNT NUMBER
  RMAN_STATUS_RECID,                       -- RMAN_STATUS_RECID NUMBER
  RMAN_STATUS_STAMP,                       -- RMAN_STATUS_STAMP NUMBER
  DEVICE_TYPE,                             -- DEVICE_TYPE VARCHAR2(17)
  TYPE,                                    -- TYPE VARCHAR2(9)
  STATUS,                                  -- STATUS VARCHAR2(11)
  FILENAME,                                -- FILENAME VARCHAR2(513)
  SET_COUNT,                               -- SET_COUNT NUMBER
  SET_STAMP,                               -- SET_STAMP NUMBER
  BUFFER_SIZE,                             -- BUFFER_SIZE NUMBER
  BUFFER_COUNT,                            -- BUFFER_COUNT NUMBER
  TOTAL_BYTES,                             -- TOTAL_BYTES NUMBER
  OPEN_TIME,                               -- OPEN_TIME DATE
  CLOSE_TIME,                              -- CLOSE_TIME DATE
  ELAPSED_TIME,                            -- ELAPSED_TIME NUMBER
  MAXOPENFILES,                            -- MAXOPENFILES NUMBER
  BYTES,                                   -- BYTES NUMBER
  EFFECTIVE_BYTES_PER_SECOND,              -- EFFECTIVE_BYTES_PER_SECOND NUMBER
  IO_COUNT,                                -- IO_COUNT NUMBER
  READY,                                   -- READY NUMBER
  SHORT_WAITS,                             -- SHORT_WAITS NUMBER
  SHORT_WAIT_TIME_TOTAL,                   -- SHORT_WAIT_TIME_TOTAL NUMBER
  SHORT_WAIT_TIME_MAX,                     -- SHORT_WAIT_TIME_MAX NUMBER
  LONG_WAITS,                              -- LONG_WAITS NUMBER
  LONG_WAIT_TIME_TOTAL,                    -- LONG_WAIT_TIME_TOTAL NUMBER
  LONG_WAIT_TIME_MAX                       -- LONG_WAIT_TIME_MAX NUMBER
from
  gv$backup_async_io
where
  inst_id = userenv('Instance')