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

本站中文解释

:

简介:Oracle 视图V$PROPAGATION_SENDER提供了日志传播客户端的信息,该信息来自日志传播服务器进程,其中包括服务器传输日志到网络及数据库结构等。

用途:该视图可以用于查看日志传播发送进程的所有相关信息,比如要发送的表名称、发送模式、当前状态等等。

使用方法:首先,你需要确保您正在使用日志传播引擎,有可以查看日志传播客户端信息的权限,然后你可以使用如下SQL查看:

SELECT * FROM V$PROPAGATION_SENDER;

官方英文解释

V$PROPAGATION_SENDER displays information about buffer queue propagation schedules on the sending (source) side. The values are reset to zero when the database (or instance in an Oracle Real Application Clusters (Oracle RAC) environment) restarts, when propagation migrates to another instance, or when an unscheduled propagation is attempted.

Column Datatype Description

QUEUE_ID

NUMBER

Queue identifier of the queue

QUEUE_SCHEMA

VARCHAR2(128)

Schema of the queue

QUEUE_NAME

VARCHAR2(128)

Name of the queue

DST_QUEUE_SCHEMA

VARCHAR2(128)

Destination schema of the queue

DST_QUEUE_NAME

VARCHAR2(128)

Name of the destination queue

STARTUP_TIME

DATE

Time at which the propagation started

DBLINK

VARCHAR2(395)

Name of the destination database link

HIGH_WATER_MARK

NUMBER

High watermark of the messages sent

ACKNOWLEDGEMENT

NUMBER

Acknowledgement of the messages received by the receiver

SCHEDULE_STATUS

VARCHAR2(128)

Status of the propagation schedule

TOTAL_MSGS

NUMBER

Total messages propagated

TOTAL_BYTES

NUMBER

Total bytes propagated

ELAPSED_DEQUEUE_TIME

NUMBER

Elapsed dequeue time (in hundredths of a second)

ELAPSED_PICKLE_TIME

NUMBER

Elapsed pickle time (time taken to linearize a logical change record (LCR) into a stream of bytes that can be sent over the network) (in hundredths of a second)

ELAPSED_PROPAGATION_TIME

NUMBER

Elapsed propagation time (in hundredths of a second)

ELAPSED_RULE_TIME

NUMBER

Elapsed rule time (in hundredths of a second)

MAX_NUM_PER_WIN

NUMBER

Maximum bytes per window

MAX_SIZE

NUMBER

Maximum bytes sent per window

LAST_MSG_LATENCY

NUMBER

Last propagated message latency

LAST_MSG_ENQUEUE_TIME

TIMESTAMP(6)

Last propagated message enqueue time

LAST_MSG_PROPAGATION_TIME

TIMESTAMP(6)

Last time when the message was propagated

LAST_LCR_LATENCY

NUMBER

Last propagated LCR latency

LAST_LCR_CREATION_TIME

DATE

Last propagated LCR timestamp

LAST_LCR_PROPAGATION_TIME

DATE

Last time when the LCR was propagated

DST_DATABASE_NAME

VARCHAR2(395)

Global name of the destination database

SESSION_ID

NUMBER

Session ID of the propagation sender process

SERIAL#

NUMBER

Serial number of the propagation sender process

SPID

VARCHAR2(24)

Process identification number of the propagation sender process

PROPAGATION_NAME

VARCHAR2(128)

Name of the propagation

STATE

VARCHAR2(128)

State of the propagation sender process:

  • Initializing

  • Initializing propagation receiver

  • Browsing LCRs

  • Evaluating rules

  • Dequeueing LCRs

  • Sending LCRs

  • Waiting for apply to be enabled

  • Waiting for apply database to start

  • Waiting for propagation to be enabled

  • Waiting for capture to terminate

  • Waiting for a subscriber to be added

  • Suspended due to a dropped subscriber

  • Suspended for auto split/merge

  • Waiting on empty queue

When the SCHEDULE_STATUS column is not SCHEDULE OPTIMIZED, the state is the value of the SCHEDULE_STATUS column.

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$PROPAGATION_SENDER 官方解释,作用,如何使用详细说明