V$BACKUP_SYNC_IO definition in Oracle Database 11.2
V$BACKUP_SYNC_IO

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
  IO_TIME_TOTAL,                           -- IO_TIME_TOTAL NUMBER
  IO_TIME_MAX,                             -- IO_TIME_MAX NUMBER
  DISCRETE_BYTES_PER_SECOND                -- DISCRETE_BYTES_PER_SECOND NUMBER
from
  gv$backup_sync_io
where
  inst_id = userenv('Instance')

home |  up