[Home] [Help] [Dependency Information]
Object Name: | GV_$GES_BLOCKING_ENQUEUE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
HANDLE | RAW | (8) | ||
GRANT_LEVEL | VARCHAR2 | (9) | ||
REQUEST_LEVEL | VARCHAR2 | (9) | ||
RESOURCE_NAME1 | VARCHAR2 | (30) | ||
RESOURCE_NAME2 | VARCHAR2 | (30) | ||
PID | NUMBER | |||
TRANSACTION_ID0 | NUMBER | |||
TRANSACTION_ID1 | NUMBER | |||
GROUP_ID | NUMBER | |||
OPEN_OPT_DEADLOCK | NUMBER | |||
OPEN_OPT_PERSISTENT | NUMBER | |||
OPEN_OPT_PROCESS_OWNED | NUMBER | |||
OPEN_OPT_NO_XID | NUMBER | |||
CONVERT_OPT_GETVALUE | NUMBER | |||
CONVERT_OPT_PUTVALUE | NUMBER | |||
CONVERT_OPT_NOVALUE | NUMBER | |||
CONVERT_OPT_DUBVALUE | NUMBER | |||
CONVERT_OPT_NOQUEUE | NUMBER | |||
CONVERT_OPT_EXPRESS | NUMBER | |||
CONVERT_OPT_NODEADLOCKWAIT | NUMBER | |||
CONVERT_OPT_NODEADLOCKBLOCK | NUMBER | |||
WHICH_QUEUE | NUMBER | |||
STATE | VARCHAR2 | (64) | ||
AST_EVENT0 | NUMBER | |||
OWNER_NODE | NUMBER | |||
BLOCKED | NUMBER | |||
BLOCKER | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, HANDLE
, GRANT_LEVEL
, REQUEST_LEVEL
, RESOURCE_NAME1
, RESOURCE_NAME2
, PID
, TRANSACTION_ID0
, TRANSACTION_ID1
, GROUP_ID
, OPEN_OPT_DEADLOCK
, OPEN_OPT_PERSISTENT
, OPEN_OPT_PROCESS_OWNED
, OPEN_OPT_NO_XID
, CONVERT_OPT_GETVALUE
, CONVERT_OPT_PUTVALUE
, CONVERT_OPT_NOVALUE
, CONVERT_OPT_DUBVALUE
, CONVERT_OPT_NOQUEUE
, CONVERT_OPT_EXPRESS
, CONVERT_OPT_NODEADLOCKWAIT
, CONVERT_OPT_NODEADLOCKBLOCK
, WHICH_QUEUE
, STATE
, AST_EVENT0
, OWNER_NODE
, BLOCKED
, BLOCKER
, CON_ID
FROM SYS.GV_$GES_BLOCKING_ENQUEUE;
|
|
|