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

VIEW: SYS.V_$GES_BLOCKING_ENQUEUE

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
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

Query Text

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


SELECT 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.V_$GES_BLOCKING_ENQUEUE;

Dependencies

[top of page]

SYS.V_$GES_BLOCKING_ENQUEUE references the following:

SYS.V_$GES_BLOCKING_ENQUEUE is referenced by following:

SchemaPUBLIC
SynonymV$GES_BLOCKING_ENQUEUE