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 an Oracle Real Application Clusters (Oracle RAC) environment) restarts, when propagation migrates to another instance, or when an unscheduled propagation is attempted.
Name of the source schema
Name of the source queue
Name of the source database
Name of the destination schema
Name of the destination queue
Startup time of this schedule. This time changes when the source/destination database gets restarted.
High watermark of the messages received
Acknowledgement of the messages received by the receiver
Last received message
Total number of messages
Elapsed unpickle time
Elapsed rule time
Elapsed enqueue time
Session ID of the propagation receiver
Serial number of the propagation receiver
Process identification number of the propagation receiver
Name of the Streams propagation on the source database
State of the propagation receiver:
Sending unapplied txns
Waiting for message from client
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.
Last received message position. Corresponds to LAST_RECEIVED_MSG, except the value is in position rather than SCN. Position is used by XStream to determine ordering.
Acknowledgement position of the messages received by the receiver. Corresponds to ACKNOWLEDGEMENT, except the value is in position rather than SCN. Position is used by XStream to determine ordering.