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`)
`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)
`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)
`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
`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
`MODULE`^Foot 1	`VARCHAR2(48)`		Module name of the session that reported the divergence
`ACTION`^Footref 1	`VARCHAR2(32)`		Action name of the session that reported the divergence

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