Oracle教程

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

本站中文解释

？

Oracle V$XSTREAM_APPLY_RECEIVER视图提供有关XStream应用接收器实例工作内部状态的信息。它是一个动态视图，包含了XStream接收端实例当前正在处理的事务日志文件、已经处理的信息等内容。

使用V$XSTREAM_APPLY_RECEIVER视图的目的是查看XStream应用接收器实例的工作状况。通过这个视图可以查看以下字段：
SRC_NAME：接收端名称
TRANS_COUNT：事务日志文件中处理的事务数
THREAD_COUNT：正在处理该事务日志文件的线程数
PROCESS_STATUS：接收端的状态
还可以通过视图查看当前接收端正在处理的文件的详细信息。

要使用V$XSTREAM_APPLY_RECEIVER视图，首先需要使用它的SQL语句来从该视图获取信息。下面是通过V$XSTREAM_APPLY_RECEIVER视图查看接收端实例的正在处理的事务日志文件的例子：

select SRC_NAME, TRANS_COUNT, THREAD_COUNT, PROCESS_STATUS
from V$XSTREAM_APPLY_RECEIVER
where PROCESS_STATUS=’RUNNING’;

官方英文解释

V$XSTREAM_APPLY_RECEIVER displays information about the message receiver of the apply process. The values are reset to zero when the database (or instance in an Oracle Real Application Clusters (Oracle RAC) environment) restarts, when apply migrates to another instance, or when the XStream 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

Acknowledgement SCN 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(44)

State of the apply receiver:

  • Initializing

  • Sending unapplied txns

  • Waiting for message from client

  • Waiting for LCR from client

  • Receiving LCRs

  • Evaluating rules

  • Enqueueing LCRS

  • Waiting for memory

  • Waiting for apply to read

  • Waiting for client flush request to complete

  • Waiting for client commit to complete

LAST_RECEIVED_MSG_POSITION

RAW(64)

Last received message position

ACKNOWLEDGEMENT_POSITION

RAW(64)

Acknowledgement 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


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

相关推荐