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 In combined capture and apply mode, the session ID of the propagation receiver
SERIAL# NUMBER In combined capture and apply mode, the serial number of the propagation receiver
SPID VARCHAR2(24) In combined capture and apply mode, the process identification number of the propagation receiver
PROPAGATION_NAME VARCHAR2(30) Name of the Streams propagation on the source database
STATE VARCHAR2(31) In combined capture and apply mode, the 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

In non-combined capture and apply mode, the state is Normal