Oracle教程 2023-03-27

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

V$GES_RESOURCE视图是Oracle中用来查看事件组资源使用情况的动态性能视图，它由V$RESOURCE和V$QUEUE视图组合而成。

V$GES_RESOURCE视图可以用来查看事件组所使用资源的细节。这些资源包括：资源类别、资源用量、本地等待时间、总等待时间、实例的登录等。

要使用V$GES_RESOURCE视图，可以运行以下SQL：

SELECT * FROM v$ges_resource WHERE resource_group=’MY_GROUP’；

这里，MY_GROUP是要查询资源使用情况的事件组名。

V$GES_RESOURCE is an Oracle Real Application Clusters view. It displays information of all resources currently known to the lock manager.

Column	Datatype	Description
`RESP`	`RAW(4 \| 8)`	Resource pointer
`RESOURCE_NAME`	`VARCHAR2(30)`	Resource name in hexadecimal for the lock
`ON_CONVERT_Q`	`NUMBER`	`1` if on convert queue, `0` otherwise
`ON_GRANT_Q`	`NUMBER`	`1` if on granted queue, `0` otherwise
`PERSISTENT_RES`	`NUMBER`	`1` if it is a persistent resource, `0` otherwise
`MASTER_NODE`	`NUMBER`	Master node ID
`NEXT_CVT_LEVEL`	`VARCHAR2(9)`	Next lock level to convert on global convert queue
`VALUE_BLK_STATE`	`VARCHAR2(32)`	State of the value block
`VALUE_BLK`	`VARCHAR2(64)`	First 64 bytes of the value block
`CACHE_LEVEL`	`NUMBER`	Level at which the resource is cached (`0`, `1`, or `2`; `255` if not on cache)
`PDBSCOPE`	`NUMBER`	Indicates whether an enqueue is PDB-scoped (`1`) or not (`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

分享到：