Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
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_SENDER

V$PROPAGATION_SENDER displays information about buffer queue propagation schedules on the sending (source) 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
QUEUE_ID NUMBER Queue identifier of the queue
QUEUE_SCHEMA VARCHAR2(30) Schema of the queue
QUEUE_NAME VARCHAR2(30) Name of the queue
DST_QUEUE_SCHEMA VARCHAR2(30) Destination schema of the queue
DST_QUEUE_NAME VARCHAR2(30) Name of the destination queue
STARTUP_TIME DATE Time at which the propagation started
DBLINK VARCHAR2(128) Name of the destination database link
HIGH_WATER_MARK NUMBER High-watermark of the messages sent
ACKNOWLEDGEMENT NUMBER Acknowledgement of the messages received by the receiver
SCHEDULE_STATUS VARCHAR2(30) Status of the propagation schedule
TOTAL_MSGS NUMBER Total messages propagated
TOTAL_BYTES NUMBER Total bytes propagated
ELAPSED_DEQUEUE_TIME NUMBER Elapsed dequeue time
ELAPSED_PICKLE_TIME NUMBER Elapsed pickle time (time taken to linearize an LCR into a stream of bytes that can be sent over the network)
ELAPSED_PROPAGATION_TIME NUMBER Elapsed propagation time