V$PROPAGATION

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 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