Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
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