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

本站中文解释

就是oracle 10g新增的视图,它是全局事务服从者和服从协调器比较常用的几个视图之一。

V$GES_CONVERT_REMOTE是管理要进行XA转换的远程分布式事务的视图。它显示了要实施提交服从的分发式内部事务的信息,包括状态,事务的XID等等。其中的一些转换可能由于网络连接断开而失败,这样V$GES_CONVERT_REMOTE可以用来重新恢复这些转换,也可以用来清楚失败的会话,以释放(以及回滚)在远程数据库上的地锁。

要使用V$GES_CONVERT_REMOTE,首先要在相关的实例上启起分发式服从跟踪。应该注意的是,如果在Oracle数据库中启起了应用服从,但要么未在分发式环境下启起,要么未启起相关的分发式服从跟踪,则V$GES_CONVERT_REMOTE视图将无法使用。

官方英文解释

V$GES_CONVERT_REMOTE displays values for remote GES enqueue conversions. 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_REMOTE 官方解释,作用,如何使用详细说明