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,
  sync_count,                              -- IO_COUNT NUMBER
  sync_tottime,                            -- IO_TIME_TOTAL NUMBER
  sync_maxtime,                            -- IO_TIME_MAX NUMBER
  decode(                                  -- DISCRETE_BYTES_PER_SECOND NUMBER
    sync_tottime, 0, NULL, round((blocks * block_size) / sync_tottime * 100)) * 1 
from
  x$ksfqp
where
  bitand(flags,2) = 0