Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 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 |
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 |