V$WORKLOAD_REPLAY_THREAD

V$WORKLOAD_REPLAY_THREAD displays information for all the different types of replay sessions.

Column Datatype Description
SID NUMBER Session ID of the replay session
SERIAL# NUMBER Session serial number of the replay session
SPID VARCHAR2(24) The server process ID of the replay session
LOGON_USER VARCHAR2(30) Logon username of the replay session
LOGON_TIME DATE Logon time of the replay session
EVENT VARCHAR2(64) Event name
EVENT_ID NUMBER Event identifier
EVENT# NUMBER Event operation code
P1TEXT VARCHAR2(64) Text for event parameter 1
P1 NUMBER Value of event parameter 1
P2TEXT VARCHAR2(64) Text for event parameter 2
P2 NUMBER Value of event parameter 2
P3TEXT VARCHAR2(64) Text for event parameter 3
P3 NUMBER Value of event parameter 3
WAIT_FOR_SCN NUMBER The captured SCN for which the current user call should wait
FILE_ID NUMBER The stream ID that is being replayed
CALL_COUNTER NUMBER The call counter of the user call that is being replayed
DEPENDENT_SCN NUMBER The dependent SCN, captured to order the commit actions using block-level dependencies
STATEMENT_SCN NUMBER Statement SCN
COMMIT_WAIT_SCN NUMBER The (maximum) SCN that the current commit should wait for
POST_COMMIT_SCN NUMBER The next SCN after the current commit
ACTION_TYPE NUMBER The type of commits. The possible values are: COMMIT, ROLLBACK, FAKED_COMMIT, and NULL. A value of NULL means it is not a commit operation.
SESSION_TYPE VARCHAR2(13) The type of replay session:

LOGON

ADMIN

DISPATCHER

REPLAY

WRC_ID NUMBER Unique replay client ID assigned by the server to all participating replay clients when replay starts
FILE_NAME VARCHAR2(30) File name of the captured stream
SKIP_IT VARCHAR2(1) Whether or not the current replayed user call is skipped or not
DIRTY_BUFFERS VARCHAR2(1) ???
DBTIME NUMBER Accumulated database time for the replay session
NETWORK_TIME NUMBER Accumulated network time for the replay session
THINK_TIME NUMBER Accumulated think time for the replay session
TIME_GAIN NUMBER If nonzero, the accumulated time in macro seconds indicating how fast the replay is
TIME_LOSS NUMBER If nonzero, the accumulated time in macro seconds indicating how slow the replay is
USER_CALLS NUMBER Total number of user calls
NEW_ERRORS NUMBER Total number of new errors
MUTATED_ERRORS NUMBER Total number of different errors
CLIENT_OS_USER VARCHAR2(15) Operating system username of the replay client
CLIENT_HOST VARCHAR2(64) Host name of the replay client
CLIENT_PID VARCHAR2(24) Process ID of the replay client
PROGRAM VARCHAR2(48) Program name of the replay client