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 |
