DBA_WORKLOAD_REPLAY_DIVERGENCE

DBA_WORKLOAD_REPLAY_DIVERGENCE displays information about data/error divergence for a user call that has been replayed.

Column Datatype NULL Description
REPLAY_ID NUMBER NOT NULL ID (key) for the workload replay
TIMESTAMP TIMESTAMP(6) WITH TIME ZONE   Time that the divergence occurred
DIVERGENCE_TYPE NUMBER NOT NULL Reserved for future use
IS_QUERY_DATA_DIVERGENCE VARCHAR2(1)   Indicates whether the data divergence is from the number of rows fetched by SELECT queries (Y) or not (N)
IS_DML_DATA_DIVERGENCE VARCHAR2(1)   Indicates whether the divergence is from the number of rows affected by INSERT, UPDATE, or DELETE SQL statements (Y) or not (N)
IS_ERROR_DIVERGENCE VARCHAR2(1)   Indicates whether the divergence is from errors seen during capture or replay (Y) or not (N)
IS_THREAD_FAILURE VARCHAR2(1)   Indicates whether the divergence is from sessions that failed during replay (Y) or not (N)
IS_DATA_MASKEDFoot 1  VARCHAR2(1)   Indicates whether the SQL call contains masked bind data (Y) or not (N).

If data masking technology is used at the replay database, the workload capture files need to be masked. Otherwise, SQL statements generated from capture files that contain sensitive bind data will not match the database. When the replay client sends masked bind data to the server, it turns on the IS_DATA_MASKED flag for the current SQL call.

EXPECTED_ROW_COUNT NUMBER   Number of rows fetched for SELECT queries or rows affected for INSERT, UPDATE, or DELETE SQL statements during capture
OBSERVED_ROW_COUNT NUMBER   Actual number of rows fetched for SELECT queries or rows affected for INSERT, UPDATE, or DELETE SQL statements during replay
EXPECTED_ERROR# NUMBER   Error number that was seen during capture (0 if the capture ran successfully)
EXPECTED_ERROR_MESSAGE VARCHAR2(4000)   Text of the error message whose number appears in the EXPECTED_ERROR# column
OBSERVED_ERROR# NUMBER   Actual error number seen during replay (0 if the replay ran successfully, 15566 (corresponding to ORA-15566) if the captured call could not be replayed)
OBSERVED_ERROR_MESSAGE VARCHAR2(4000)   Text of the error message whose number appears in the OBSERVED_ERROR# column
STREAM_ID NUMBER NOT NULL Stream ID of the session that reported the divergence
CALL_COUNTER NUMBER NOT NULL Call counter of the user call that reported the divergence
CAPTURE_STREAM_IDFootref 1 NUMBER   Internal ID of the capture file whose replay produced the divergence
SQL_ID VARCHAR2(13)   SQL ID of the SQL that reported the divergence
SESSION_ID NUMBER NOT NULL Session ID of the session that reported the divergence
SESSION_SERIAL# NUMBER NOT NULL Captured session serial number of the session that reported the divergence
SERVICE VARCHAR2(64)   Service name of the session that reported the divergence
MODULEFoot 2  VARCHAR2(64)   Module name of the session that reported the divergence
ACTIONFootref 2 VARCHAR2(64)   Action name of the session that reported the divergence

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.4)

Footnote 2 The datatype of this column is VARCHAR2(64) starting with Oracle Database 11g Release 2 (11.2.0.2).