Oracle教程 2023-03-20

Oracle 视图 V$GES_ENQUEUE 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$GES_ENQUEUE可以用于查看系统正在保持的Global Enqueue Services（GES）锁信息。有时也可以使用它来调试GES锁相关问题或检查锁竞争状况。

要使用此视图，可以使用下面一条SQL语句：

SELECT * FROM V$GES_ENQUEUE;

这条语句将会显示系统中所有当前正在保持的GES锁信息，其中包括请求锁的实例ID，锁的类型，请求的模式，以及锁是否已被授予等内容。

官方英文解释

V$GES_ENQUEUE describes all locks currently known to lock manager. This is an Oracle Real Application Clusters view.

See Also:

“V$GES_BLOCKING_ENQUEUE” for a description of all such locks that are currently blocking or being blocked

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 to which the lock belongs
`TRANSACTION_ID1`	`NUMBER`	Upper 4 bytes of the transaction identifier to which the lock belongs
`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 the lock as the 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

数据运维技术 » Oracle 视图 V$GES_ENQUEUE 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐