Oracle教程

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

本站中文解释

_CR

Oracle视图V$GES_CONVERT_LOCAL_CR是一个重要的视图，它提供了全局事务服务器(Global Transaction Server,GTS)分布式异步消息传递所需的信息。V$GES_CONVERT_LOCAL_CR提供有关事务分布式处理的低级详细信息，也就是全局事务恢复时消息的本地站点。它可以用于对实例内积极活动的分布式处理，以及这些处理在什么时候发生，以及发生哪些处理，以及处理如何影响整个事务处理过程，等等。

要使用V$GES_CONVERT_LOCAL_CR视图，首先需要具备一定的Oracle DBA技能，之后在SQL*Plus中根据表结构执行 SELECT 语句，以方便查看该视图内容。在SQL*Plus中查询V$GES_CONVERT_LOCAL_CR可以使用如下语句：

SELECT * FROM v$ges_convert_local_cr;

该命令将列出V$GES_CONVERT_LOCAL_CR视图的所有内容，以便查看有关分布式处理的详细信息。

官方英文解释

V$GES_CONVERT_LOCAL displays statistics for local GES enqueue operations. This view records average convert times, count information, and timed statistics for global enqueue requests.

Column Datatype Description

INST_ID

NUMBER

ID of the instance

CONVERT_TYPE

VARCHAR2(16)

Conversion type:

  • NULL -> SS – NULL mode to subshared mode

  • NULL -> SX – NULL mode to shared exclusive mode

  • NULL -> S – NULL mode to shared mode

  • NULL -> SSX – NULL mode to subshared exclusive mode

  • NULL -> X – NULL mode to exclusive mode

  • SS -> SX – Subshared mode to shared exclusive mode

  • SS -> S – Subshared mode to shared mode

  • SS -> SSX – Subshared mode to subshared exclusive mode

  • SS -> X – Subshared mode to exclusive mode

  • SX -> S – Shared exclusive mode to shared mode

  • SX -> SSX – Shared exclusive mode to subshared exclusive mode

  • SX -> X – Shared exclusive mode to exclusive mode

  • S -> SX – Shared mode to shared exclusive mode

  • S -> SSX – Shared mode to subshared exclusive mode

  • S -> X – Shared mode to exclusive mode

  • SSX -> X – Sub-shared exclusive mode to exclusive mode

AVERAGE_CONVERT_TIME

NUMBER

Average conversion time for each type of lock operation (in hundredths of a second)

CONVERT_COUNT

NUMBER

Number of operations

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_CONVERT_LOCAL 官方解释，作用，如何使用详细说明
分享到：

相关推荐