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 Streams propagation |
|
|
State of the propagation sender process:
When the |
|
|
The ID of the container to which the data pertains. Possible values include:
|