VIEW: SYS.DBA_WORKLOAD_REPLAY_DIVERGENCE

Source

View Text - Preformatted

select
 rd.id
 , rd.time
 , rd.type
 , decode(bitand(rd.type, 1), 0, 'N','Y') as IS_QUERY_DATA_DIVERGENCE
 , decode(bitand(rd.type, 2), 0, 'N','Y') as IS_DML_DATA_DIVERGENCE
 , decode(bitand(rd.type, 4), 0, 'N','Y') as IS_ERROR_DIVERGENCE
 , decode(bitand(rd.type,16), 0, 'N','Y') as IS_THREAD_FAILURE
 , decode(bitand(rd.type,64), 0, 'N','Y') as IS_DATA_MASKED
 , rd.exp_num_rows
 , rd.obs_num_rows
 , rd.exp_error
 , decode(rd.exp_error, 0, NULL, dbms_advisor.format_message(rd.exp_error))
 , rd.obs_error
 , decode(rd.obs_error, 0, NULL, dbms_advisor.format_message(rd.obs_error))
 , rd.file_id
 , rd.call_counter
 , rd.cap_file_id
 , rd.sql_id
 , rd.session_id
 , rd.session_serial#
 , rd.service
 , substrb(rd.module,1,(select ksumodlen from x$modact_length)) module
 , substrb(rd.action,1,(select ksuactlen from x$modact_length)) action
 from  WRR$_REPLAY_DIVERGENCE rd, WRR$_REPLAYS r
 where r.id = rd.id
 and   nvl(r.replay_type, 'DB') = 'DB'

View Text - HTML Formatted

SELECT RD.ID
, RD.TIME
, RD.TYPE
, DECODE(BITAND(RD.TYPE
, 1)
, 0
, 'N'
, 'Y') AS IS_QUERY_DATA_DIVERGENCE
, DECODE(BITAND(RD.TYPE
, 2)
, 0
, 'N'
, 'Y') AS IS_DML_DATA_DIVERGENCE
, DECODE(BITAND(RD.TYPE
, 4)
, 0
, 'N'
, 'Y') AS IS_ERROR_DIVERGENCE
, DECODE(BITAND(RD.TYPE
, 16)
, 0
, 'N'
, 'Y') AS IS_THREAD_FAILURE
, DECODE(BITAND(RD.TYPE
, 64)
, 0
, 'N'
, 'Y') AS IS_DATA_MASKED
, RD.EXP_NUM_ROWS
, RD.OBS_NUM_ROWS
, RD.EXP_ERROR
, DECODE(RD.EXP_ERROR
, 0
, NULL
, DBMS_ADVISOR.FORMAT_MESSAGE(RD.EXP_ERROR))
, RD.OBS_ERROR
, DECODE(RD.OBS_ERROR
, 0
, NULL
, DBMS_ADVISOR.FORMAT_MESSAGE(RD.OBS_ERROR))
, RD.FILE_ID
, RD.CALL_COUNTER
, RD.CAP_FILE_ID
, RD.SQL_ID
, RD.SESSION_ID
, RD.SESSION_SERIAL#
, RD.SERVICE
, SUBSTRB(RD.MODULE
, 1
, (SELECT KSUMODLEN
FROM X$MODACT_LENGTH)) MODULE
, SUBSTRB(RD.ACTION
, 1
, (SELECT KSUACTLEN
FROM X$MODACT_LENGTH)) ACTION
FROM WRR$_REPLAY_DIVERGENCE RD
, WRR$_REPLAYS R
WHERE R.ID = RD.ID
AND NVL(R.REPLAY_TYPE
, 'DB') = 'DB'