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(66) |
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(66) |
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 |
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 |