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

本站中文解释

Oracle视图V$GES_BLOCKING_ENQUEUE提供了关于当前数据库中执行的GES阻塞信号捕获任务的情况。

该视图会显示在当前数据库中哪些事件对同一段被等待,以及为何这些事件阻塞,以及阻塞的事件资源,阻塞的会话等等信息。它也显示了正在争用资源的会话的详细信息。

使用方法:

要查看V$GES_BLOCKING_ENQUEUE中的信息,只需要使用常见的SELECT语句来查询它即可。例如:

SELECT * FROM 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


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