GV$BACKUP_SYNC_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,
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
home |  up  |  mailbox