[Home] [Help] [Dependency Information]
Object Name: | V_$WORKLOAD_REPLAY_THREAD |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
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 |
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;
|
|
|