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

VIEW: SYS.V_$WORKLOAD_REPLAY_THREAD

Object Details
Object Name: V_$WORKLOAD_REPLAY_THREAD
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CLOCK NUMBER

NEXT_TICKER NUMBER

SID NUMBER

SERIAL# NUMBER

SPID VARCHAR2 (24)
LOGON_USER VARCHAR2 (30)
LOGON_TIME DATE

EVENT VARCHAR2 (64)
EVENT_ID NUMBER

EVENT# NUMBER

P1TEXT VARCHAR2 (64)
P1 NUMBER

P2TEXT VARCHAR2 (64)
P2 NUMBER

P3TEXT VARCHAR2 (64)
P3 NUMBER

WAIT_FOR_SCN NUMBER

FILE_ID NUMBER

CALL_COUNTER NUMBER

DEPENDENT_SCN NUMBER

STATEMENT_SCN NUMBER

COMMIT_WAIT_SCN NUMBER

POST_COMMIT_SCN NUMBER

ACTION_TYPE NUMBER

SESSION_TYPE VARCHAR2 (13)
WRC_ID NUMBER

FILE_NAME VARCHAR2 (31)
SKIP_IT VARCHAR2 (1)
DIRTY_BUFFERS VARCHAR2 (1)
DBTIME NUMBER

NETWORK_TIME NUMBER

THINK_TIME NUMBER

TIME_GAIN NUMBER

TIME_LOSS NUMBER

USER_CALLS NUMBER

CLIENT_OS_USER VARCHAR2 (15)
CLIENT_HOST VARCHAR2 (64)
CLIENT_PID VARCHAR2 (24)
PROGRAM VARCHAR2 (48)
CON_ID NUMBER

Query Text

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


SELECT CLOCK
,      NEXT_TICKER
,      SID
,      SERIAL#
,      SPID
,      LOGON_USER
,      LOGON_TIME
,      EVENT
,      EVENT_ID
,      EVENT#
,      P1TEXT
,      P1
,      P2TEXT
,      P2
,      P3TEXT
,      P3
,      WAIT_FOR_SCN
,      FILE_ID
,      CALL_COUNTER
,      DEPENDENT_SCN
,      STATEMENT_SCN
,      COMMIT_WAIT_SCN
,      POST_COMMIT_SCN
,      ACTION_TYPE
,      SESSION_TYPE
,      WRC_ID
,      FILE_NAME
,      SKIP_IT
,      DIRTY_BUFFERS
,      DBTIME
,      NETWORK_TIME
,      THINK_TIME
,      TIME_GAIN
,      TIME_LOSS
,      USER_CALLS
,      CLIENT_OS_USER
,      CLIENT_HOST
,      CLIENT_PID
,      PROGRAM
,      CON_ID
FROM SYS.V_$WORKLOAD_REPLAY_THREAD;

Dependencies

[top of page]

SYS.V_$WORKLOAD_REPLAY_THREAD references the following:

SYS.V_$WORKLOAD_REPLAY_THREAD is referenced by following:

SchemaPUBLIC
SynonymV$WORKLOAD_REPLAY_THREAD