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)
`ELAPSED_RULE_TIME`	`NUMBER`	Elapsed rule 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
`SESSION_ID`	`NUMBER`	Session ID of the propagation sender process
`SERIAL#`	`NUMBER`	Serial number of the propagation sender process
`SPID`	`VARCHAR2(24)`	Process identification number of the propagation sender process
`PROPAGATION_NAME`	`VARCHAR2(30)`	Name of the Streams propagation
`STATE`	`VARCHAR2(53)`	State of the propagation sender process: `Initializing` `Initializing propagation receiver` `Browsing LCRs` `Evaluating rules` `Dequeueing LCRs` `Sending LCRs` `Waiting for apply to be enabled` `Waiting for apply database to start` `Waiting for propagation to be enabled` `Waiting for capture to terminate` `Waiting for a subscriber to be added` `Suspended due to a dropped subscriber` `Suspended for auto split/merge` `Waiting on empty queue` When the `SCHEDULE_STATUS` column is not `SCHEDULE OPTIMIZED`, the state is the value of the `SCHEDULE_STATUS` column.