V$PROPAGATION_RECEIVER

V$PROPAGATION_RECEIVER displays information about buffer queue propagation schedules on the receiving (destination) 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
`SRC_QUEUE_SCHEMA`	`VARCHAR2(30)`	Name of the source schema
`SRC_QUEUE_NAME`	`VARCHAR2(30)`	Name of the source queue
`SRC_DBNAME`	`VARCHAR2(128)`	Name of the source database
`DST_QUEUE_SCHEMA`	`VARCHAR2(30)`	Name of the destination schema
`DST_QUEUE_NAME`	`VARCHAR2(30)`	Name of the destination queue
`STARTUP_TIME`	`DATE`	Startup time of this schedule. This time changes when the source/destination database gets restarted.
`HIGH_WATER_MARK`	`NUMBER`	High-watermark of the messages received
`ACKNOWLEDGEMENT`	`NUMBER`	Acknowledgement of the messages received by the receiver
`LAST_RECEIVED_MSG`	`NUMBER`	Last received message
`TOTAL_MSGS`	`NUMBER`	Total number of messages
`ELAPSED_UNPICKLE_TIME`	`NUMBER`	Elapsed unpickle time
`ELAPSED_RULE_TIME`	`NUMBER`	Elapsed rule time
`ELAPSED_ENQUEUE_TIME`	`NUMBER`	Elapsed enqueue time
`SESSION_ID`	`NUMBER`	Session ID of the propagation receiver
`SERIAL#`	`NUMBER`	Serial number of the propagation receiver
`SPID`	`VARCHAR2(24)`	Process identification number of the propagation receiver
`PROPAGATION_NAME`	`VARCHAR2(30)`	Name of the Streams propagation on the source database
`STATE`	`VARCHAR2(43)`	State of the propagation receiver: `Initializing` `Sending unapplied txns` `Waiting for message from client` `Receiving LCRs` `Evaluating rules` `Enqueueing LCRS` `Waiting for memory` `Waiting for apply to read` `Waiting for message from propagation sender` When the propagation schedule is not optimized, the state is `Normal`.