Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$WORKLOAD_REPLAY_THREAD

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

Column Datatype Description
CLOCK NUMBER Current simulated SCN based on the SCN recorded at capture time
NEXT_TICKER NUMBER Next stream ID that will increment the CLOCK after a commit action
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(31) 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) Reserved for internal use
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
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