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 a Real Application Clusters (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(30) |
Schema of the queue |
QUEUE_NAME |
VARCHAR2(30) |
Name of the queue |
DST_QUEUE_SCHEMA |
VARCHAR2(30) |
Destination schema of the queue |
DST_QUEUE_NAME |
VARCHAR2(30) |
Name of the destination queue |
STARTUP_TIME |
DATE |
Time at which the propagation started |
DBLINK |
VARCHAR2(128) |
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(30) |
Status of the propagation schedule |
TOTAL_MSGS |
NUMBER |
Total messages propagated |
TOTAL_BYTES |
NUMBER |
Total bytes propagated |
ELAPSED_DEQUEUE_TIME |
NUMBER |
Elapsed dequeue time |
ELAPSED_PICKLE_TIME |
NUMBER |
Elapsed pickle time (time taken to linearize an LCR into a stream of bytes that can be sent over the network) |
ELAPSED_PROPAGATION_TIME |
NUMBER |
Elapsed propagation time |