Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
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
PDF · Mobi · ePub

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 an Oracle Real Application Clusters (Oracle 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.

LAST_RECEIVED_MSG_POSITION RAW(64) 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 RAW(64) 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.
CON_ID NUMBER The ID of the container to which the data pertains. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data