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 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 (in hundredths of a second)
`ELAPSED_PICKLE_TIME`	`NUMBER`	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`	`NUMBER`	Elapsed propagation time (in hundredths of a second)
`MAX_NUM_PER_WIN`	`NUMBER`	Maximum bytes per window
`MAX_SIZE`	`NUMBER`	Maximum bytes sent per window
`LAST_MSG_LATENCY`	`NUMBER`	Last propagated message latency
`LAST_MSG_ENQUEUE_TIME`	`TIMESTAMP(6)`	Last propagated message enqueue time
`LAST_MSG_PROPAGATION_TIME`	`TIMESTAMP(6)`	Last time when the message was propagated
`LAST_LCR_LATENCY`	`NUMBER`	Last propagated LCR latency
`LAST_LCR_CREATION_TIME`	`DATE`	Last propagated LCR timestamp
`LAST_LCR_PROPAGATION_TIME`	`DATE`	Last time when the LCR was propagated
`DST_DATABASE_NAME`	`VARCHAR2(128)`	Global name of the destination database