Oracle教程

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

本站中文解释

Oracle视图V$GCR_ACTIONS是一个动态性统计视图，它主要查看在Cache Fusion（进行缓存复制）中事物中使用的全局缓存请求（Global Cache Requests）的信息。它包括了统计前后的CRC记录，另外分布在每一个实例的状况。

要使用V$GCR_ACTIONS视图，首先要确保 Oracle 高可用性（RAC）环境已经开启。为了使用这个视图，可以通过以下SQL语句：

SELECT INST_ID, GLOBAL_ENQUEUE_ACTIONS, GLOBAL_DEQUEUE_ACTIONS, GLOBAL_TRANSMITS, GLOBAL_RECEIVE_PENDING FROM V$GCR_ACTIONS;

以上SQL语句将显示每一个INST_ID，及相应地GLOBAL_ENQUEUE_ACTIONS， GLOBAL_DEQUEUE_ACTIONS， GLOBAL_TRANSMITS， GLOBAL_RECEIVE_PENDING记录。

V$GCR_ACTIONS视图可以用于检测在Cache Fusion中事物产生的活动，它可以帮助用户发现性能瓶颈，并且在高可用性环境下，能够有效的优化性能。

官方英文解释

V$GCR_ACTIONS displays information about the current status of the actions defined to the GCR component that runs under the LMHB background process to detect and mitigate potential issues in the cluster instances.

Column Datatype Description

ACTION_ID

NUMBER

Action identification number as used internally to refer to the metric

ACTION_NAME

VARCHAR2(40)

Name of the action

ENVIRONMENT

NUMBER

Environment that the action should run in:

  • 0: Nowhere (do not run)

  • 1: Oracle ASM instance only

  • 2: Oracle Database instance only

  • 3: Oracle ASM and Oracle Database instance

  • 4: Standby instance

  • 5: Oracle ASM and Standby instance

  • 6: Oracle Database and Standby instance

  • 7: Oracle Database, Oracle ASM, and Standby instance

  • 15: All instance types

FLAGS

NUMBER

Various flags describing the action. Used only by Oracle for diagnosis.

ACTIVE

VARCHAR2(9)
Whether the action is active or not:

  • ACTIVE: Action is active.

  • INACTIVE: Action is disabled.

STATUS_CHANGE_TIME

TIMESTAMP(6)

Time of last action change of status

LAST_RAN_ITERATION

NUMBER

Iteration of the last time the action ran

LAST_RAN_TIME

TIMESTAMP(6)

Time of last run

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

相关推荐