Oracle教程 2023-03-27

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

本站中文解释

Oracle视图V$PROPAGATION_RECEIVER用于检索服务器上注册的复制传播接收器信息。它包括延迟、自动发送和未处理的传播。

用法：

查询所有注册的传播接收器：

select * from v$propagation_receiver;

查询延迟的带有标识符的传播接受器：

select * from v$propagation_receiver where delay_seconds > 0 and identifiant is not null;

官方英文解释

V$PROPAGATION_RECEIVER displays information about buffer queue propagation schedules on the receiving (destination) 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
`SRC_QUEUE_SCHEMA`	`VARCHAR2(128)`	Name of the source schema
`SRC_QUEUE_NAME`	`VARCHAR2(128)`	Name of the source queue
`SRC_DBNAME`	`VARCHAR2(395)`	Name of the source database
`DST_QUEUE_SCHEMA`	`VARCHAR2(128)`	Name of the destination schema
`DST_QUEUE_NAME`	`VARCHAR2(128)`	Name of the destination queue
`STARTUP_TIME`	`DATE`	Startup time of this schedule. This time changes when the source/destination database gets restarted.
`HIGH_WATER_MARK`	`NUMBER`	High watermark of the messages received
`ACKNOWLEDGEMENT`	`NUMBER`	Acknowledgement of the messages received by the receiver
`LAST_RECEIVED_MSG`	`NUMBER`	Last received message
`TOTAL_MSGS`	`NUMBER`	Total number of messages
`ELAPSED_UNPICKLE_TIME`	`NUMBER`	Elapsed unpickle time
`ELAPSED_RULE_TIME`	`NUMBER`	Elapsed rule time
`ELAPSED_ENQUEUE_TIME`	`NUMBER`	Elapsed enqueue time
`SESSION_ID`	`NUMBER`	Session ID of the propagation receiver
`SERIAL#`	`NUMBER`	Serial number of the propagation receiver
`SPID`	`VARCHAR2(24)`	Process identification number of the propagation receiver
`PROPAGATION_NAME`	`VARCHAR2(128)`	Name of the propagation on the source database
`STATE`	`VARCHAR2(43)`	State of the propagation 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 propagation sender` When the propagation schedule is not optimized, the state is `Normal`.
`LAST_RECEIVED_MSG_POSITION`	`RAW(64)`	Last received message position. Corresponds to `LAST_RECEIVED_MSG`, except the value is in position rather than SCN. Position is used by XStream to determine ordering.
`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. Position is used by XStream to determine ordering.
`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_RECEIVER 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐