Oracle教程

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

本站中文解释

Oracle视图V$gg_apply_receiver是V$视图簇的一部分，主要用于显示和汇总GoldenGate应用引擎的状态和配置信息。其中，V$gg_apply_receiver视图用于显示正在处理Goldengate抽取流的Oracle Apply接收器状态。

使用V$gg_apply_receiver视图可以检查Oracle Apply接收器的当前状态，这对于诊断/诊断和性能调整都是非常有用的。
查询示例：

SELECT * FROM V$GG_APPLY_RECEIVER;

官方英文解释

V$GG_APPLY_RECEIVER displays information about the message receiver of the Replicat process.

The values are reset to zero when the database (or instance in an Oracle Real Application Clusters (Oracle RAC) environment) restarts and when the Replicat process is stopped.

Column Datatype Description

SID

NUMBER

Session ID of the apply receiver

SERIAL#

NUMBER

Serial number of the apply receiver

APPLY_NAME

VARCHAR2(128)

Name of the apply process

STARTUP_TIME

DATE

Startup time of the apply process

SOURCE_DATABASE_NAME

VARCHAR2(128)

Name of the source database

ACKNOWLEDGEMENT

NUMBER

acknowledgment of the messages received by the receiver

LAST_RECEIVED_MSG

NUMBER

Last received message

TOTAL_MESSAGES_RECEIVED

NUMBER

Total number of messages received

TOTAL_AVAILABLE_MESSAGES

NUMBER

Number of available messages

STATE

VARCHAR2(46)

State of the apply receiver:

  • Initializing

  • Sending unapplied txns

  • Waiting for message from client

  • Receiving LCRs

  • Evaluating rules

  • Enqueueing LCRS

  • Waiting for memory

  • Waiting for apply to read

  • Waiting for message from Replicat

  • Waiting for Replicat flush request to complete

  • Waiting for Replicat commit to complete

LAST_RECEIVED_MSG_POSITION

VARCHAR2(64)

Last received message position

ACKNOWLEDGEMENT_POSITION

VARCHAR2(64)

acknowledgment position of the messages received by the receiver. Corresponds to ACKNOWLEDGEMENT, except the value is in position rather than SCN.

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

OS_PROCESS_ID

VARCHAR2(12)

The OS process ID of the apply receiver process

CURRENT_POSITION

VARCHAR2(81)

The trail position of the current record processed by the apply receiver

TOTAL_TRANSACTIONS

NUMBER

The total number of transactions processed by the apply receiver

TOTAL_COMMITS

NUMBER

The total number of commits executed by the apply receiver

TOTAL_ERRORS

NUMBER

The total number of errors encountered by the apply receiver


数据运维技术 » Oracle 视图 V$GG_APPLY_RECEIVER 官方解释，作用，如何使用详细说明
分享到：

相关推荐