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