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 identifier of the queue |
|
|
Schema of the queue |
|
|
Name of the queue |
|
|
Destination schema of the queue |
|
|
Name of the destination queue |
|
|
Time at which the propagation started |
|
|
Name of the destination database link |
|
|
High watermark of the messages sent |
|
|
Acknowledgement of the messages received by the receiver |
|
|
Status of the propagation schedule |
|
|
Total messages propagated |
|
|
Total bytes propagated |
|
|
Elapsed dequeue time (in hundredths of a second) |
|
|
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 (in hundredths of a second) |
|
|
Elapsed rule time (in hundredths of a second) |
|
|
Maximum bytes per window |
|
|
Maximum bytes sent per window |
|
|
Last propagated message latency |
|
|
Last propagated message enqueue time |
|
|
Last time when the message was propagated |
|
|
Last propagated LCR latency |
|
|
Last propagated LCR timestamp |
|
|
Last time when the LCR was propagated |
|
|
Global name of the destination database |
|
|
Session ID of the propagation sender process |
|
|
Serial number of the propagation sender process |
|
|
Process identification number of the propagation sender process |
|
|
Name of the propagation |
|
|
State of the propagation sender process:
When the |
|
|
The ID of the container to which the data pertains. Possible values include:
|