Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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.