[Home] [Help] [Dependency Information]
Object Name: | V_$WAIT_CHAINS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHAIN_ID | NUMBER | |||
CHAIN_IS_CYCLE | VARCHAR2 | (5) | ||
CHAIN_SIGNATURE | VARCHAR2 | (801) | ||
CHAIN_SIGNATURE_HASH | NUMBER | |||
INSTANCE | NUMBER | |||
OSID | VARCHAR2 | (25) | ||
PID | NUMBER | |||
SID | NUMBER | |||
SESS_SERIAL# | NUMBER | |||
PDB_ID | NUMBER | |||
PDB_NAME | VARCHAR2 | (31) | ||
BLOCKER_IS_VALID | VARCHAR2 | (5) | ||
BLOCKER_INSTANCE | NUMBER | |||
BLOCKER_OSID | VARCHAR2 | (25) | ||
BLOCKER_PID | NUMBER | |||
BLOCKER_SID | NUMBER | |||
BLOCKER_SESS_SERIAL# | NUMBER | |||
BLOCKER_PDB_ID | NUMBER | |||
BLOCKER_PDB_NAME | VARCHAR2 | (31) | ||
BLOCKER_CHAIN_ID | NUMBER | |||
IN_WAIT | VARCHAR2 | (5) | ||
TIME_SINCE_LAST_WAIT_SECS | NUMBER | |||
WAIT_ID | NUMBER | |||
WAIT_EVENT | NUMBER | |||
WAIT_EVENT_TEXT | VARCHAR2 | (64) | ||
P1 | NUMBER | |||
P1_TEXT | VARCHAR2 | (64) | ||
P2 | NUMBER | |||
P2_TEXT | VARCHAR2 | (64) | ||
P3 | NUMBER | |||
P3_TEXT | VARCHAR2 | (64) | ||
IN_WAIT_SECS | NUMBER | |||
TIME_REMAINING_SECS | NUMBER | |||
NUM_WAITERS | NUMBER | |||
ROW_WAIT_OBJ# | NUMBER | |||
ROW_WAIT_FILE# | NUMBER | |||
ROW_WAIT_BLOCK# | NUMBER | |||
ROW_WAIT_ROW# | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CHAIN_ID
, CHAIN_IS_CYCLE
, CHAIN_SIGNATURE
, CHAIN_SIGNATURE_HASH
, INSTANCE
, OSID
, PID
, SID
, SESS_SERIAL#
, PDB_ID
, PDB_NAME
, BLOCKER_IS_VALID
, BLOCKER_INSTANCE
, BLOCKER_OSID
, BLOCKER_PID
, BLOCKER_SID
, BLOCKER_SESS_SERIAL#
, BLOCKER_PDB_ID
, BLOCKER_PDB_NAME
, BLOCKER_CHAIN_ID
, IN_WAIT
, TIME_SINCE_LAST_WAIT_SECS
, WAIT_ID
, WAIT_EVENT
, WAIT_EVENT_TEXT
, P1
, P1_TEXT
, P2
, P2_TEXT
, P3
, P3_TEXT
, IN_WAIT_SECS
, TIME_REMAINING_SECS
, NUM_WAITERS
, ROW_WAIT_OBJ#
, ROW_WAIT_FILE#
, ROW_WAIT_BLOCK#
, ROW_WAIT_ROW#
, CON_ID
FROM SYS.V_$WAIT_CHAINS;
|
|
|