V$GES_BLOCKING_ENQUEUE

V$GES_BLOCKING_ENQUEUE describes all locks currently known to lock manager that are being blocked or blocking others. The output of this view is a subset of the output from V$GES_ENQUEUE. This is an Oracle Real Application Clusters view.

See Also:

"V$GES_ENQUEUE" for a description of all locks known to the lock manager

Column	Datatype	Description
`HANDLE`	`RAW(4 \| 8)`	Lock pointer
`GRANT_LEVEL`	`VARCHAR2(9)`	Granted level of the lock
`REQUEST_LEVEL`	`VARCHAR2(9)`	Requested level of the lock
`RESOURCE_NAME1`	`VARCHAR2(30)`	Resource name for the lock
`RESOURCE_NAME2`	`VARCHAR2(30)`	Resource name for the lock
`PID`	`NUMBER`	Process identifier which holds the lock
`TRANSACTION_ID0`	`NUMBER`	Lower 4 bytes of the transaction identifier where the lock belongs to
`TRANSACTION_ID1`	`NUMBER`	Upper 4 bytes of the transaction identifier where the lock belongs to
`GROUP_ID`	`NUMBER`	Group identifier for the lock
`OPEN_OPT_DEADLOCK`	`NUMBER`	`1` if `DEADLOCK` open option is set, otherwise `0`
`OPEN_OPT_PERSISTENT`	`NUMBER`	`1` if `PERSISTENT` open option is set, otherwise `0`
`OPEN_OPT_PROCESS_OWNED`	`NUMBER`	`1` if `PROCESS_OWNED` open option is set, otherwise `0`
`OPEN_OPT_NO_XID`	`NUMBER`	`1` if `NO_XID` open option is set, otherwise `0`
`CONVERT_OPT_GETVALUE`	`NUMBER`	`1` if `GETVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_PUTVALUE`	`NUMBER`	`1` if `PUTVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_NOVALUE`	`NUMBER`	`1` if `NOVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_DUBVALUE`	`NUMBER`	`1` if `DUBVALUE` convert option is set, otherwise `0`
`CONVERT_OPT_NOQUEUE`	`NUMBER`	`1` if `NOQUEUE` convert option is set, otherwise `0`
`CONVERT_OPT_EXPRESS`	`NUMBER`	`1` if `EXPRESS` convert option is set, otherwise `0`
`CONVERT_OPT_NODEADLOCKWAIT`	`NUMBER`	`1` if `NODEADLOCKWAIT` convert option is set, otherwise `0`
`CONVERT_OPT_NODEADLOCKBLOCK`	`NUMBER`	`1` if `NODEADLOCKBLOCK` convert option is set, otherwise `0`
`WHICH_QUEUE`	`NUMBER`	Which queue the lock is currently located. `0` for NULL queue; `1` for GRANTED queue; `2` for CONVERT queue.
`STATE`	`VARCHAR2(64)`	State of lock as owner sees it
`AST_EVENT0`	`NUMBER`	Last AST event
`OWNER_NODE`	`NUMBER`	Node identifier
`BLOCKED`	`NUMBER`	`1` if this lock request is blocked by others, otherwise `0`
`BLOCKER`	`NUMBER`	`1` if this lock is blocking others, otherwise `0`
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data