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 |
VARCHAR2(48) |
Module name of the session that reported the divergence | |
ACTION |
VARCHAR2(32) |
Action name of the session that reported the divergence |