DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_WORKLOAD_REPLAY_DIVERGENCE

Object Details
Object Name: DBA_WORKLOAD_REPLAY_DIVERGENCE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REPLAY_ID NUMBER
Yes
TIMESTAMP TIMESTAMP(6) WITH TIME ZONE (13)
DIVERGENCE_TYPE NUMBER
Yes
IS_QUERY_DATA_DIVERGENCE VARCHAR2 (1)
IS_DML_DATA_DIVERGENCE VARCHAR2 (1)
IS_ERROR_DIVERGENCE VARCHAR2 (1)
IS_THREAD_FAILURE VARCHAR2 (1)
IS_DATA_MASKED VARCHAR2 (1)
EXPECTED_ROW_COUNT NUMBER

OBSERVED_ROW_COUNT NUMBER

EXPECTED_ERROR# NUMBER

EXPECTED_ERROR_MESSAGE VARCHAR2 (4000)
OBSERVED_ERROR# NUMBER

OBSERVED_ERROR_MESSAGE VARCHAR2 (4000)
STREAM_ID NUMBER
Yes
CALL_COUNTER NUMBER
Yes
CAPTURE_STREAM_ID NUMBER

SQL_ID VARCHAR2 (13)
SESSION_ID NUMBER
Yes
SESSION_SERIAL# NUMBER
Yes
SERVICE VARCHAR2 (64)
MODULE VARCHAR2 (64)
ACTION VARCHAR2 (64)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REPLAY_ID
,      TIMESTAMP
,      DIVERGENCE_TYPE
,      IS_QUERY_DATA_DIVERGENCE
,      IS_DML_DATA_DIVERGENCE
,      IS_ERROR_DIVERGENCE
,      IS_THREAD_FAILURE
,      IS_DATA_MASKED
,      EXPECTED_ROW_COUNT
,      OBSERVED_ROW_COUNT
,      EXPECTED_ERROR#
,      EXPECTED_ERROR_MESSAGE
,      OBSERVED_ERROR#
,      OBSERVED_ERROR_MESSAGE
,      STREAM_ID
,      CALL_COUNTER
,      CAPTURE_STREAM_ID
,      SQL_ID
,      SESSION_ID
,      SESSION_SERIAL#
,      SERVICE
,      MODULE
,      ACTION
FROM SYS.DBA_WORKLOAD_REPLAY_DIVERGENCE;

Dependencies

[top of page]

SYS.DBA_WORKLOAD_REPLAY_DIVERGENCE references the following:

SchemaSYS
PL/SQL PackageDBMS_ADVISOR - show dependent code
TableWRR$_REPLAYS
TableWRR$_REPLAY_DIVERGENCE
SYS.DBA_WORKLOAD_REPLAY_DIVERGENCE is referenced by following:

SchemaPUBLIC
SynonymDBA_WORKLOAD_REPLAY_DIVERGENCE
SchemaSYS
Package BodyDBMS_WORKLOAD_REPLAY - show dependent code
Package BodyDBMS_WRR_INTERNAL - show dependent code