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

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

Go to previous page
Go to next page
View PDF


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 (in hundredths of a second)
ELAPSED_PICKLE_TIME NUMBER Elapsed pickle time (time taken to linearize a logical change record (LCR) into a stream of bytes that can be sent over the network) (in hundredths of a second)
ELAPSED_PROPAGATION_TIME NUMBER Elapsed propagation time (in hundredths of a second)
MAX_NUM_PER_WIN NUMBER Maximum bytes per window
MAX_SIZE NUMBER Maximum bytes sent per window
LAST_MSG_LATENCY NUMBER Last propagated message latency
LAST_MSG_ENQUEUE_TIME TIMESTAMP(6) Last propagated message enqueue time
LAST_MSG_PROPAGATION_TIME TIMESTAMP(6) Last time when the message was propagated
LAST_LCR_LATENCY NUMBER Last propagated LCR latency
LAST_LCR_CREATION_TIME DATE Last propagated LCR timestamp
LAST_LCR_PROPAGATION_TIME DATE Last time when the LCR was propagated
DST_DATABASE_NAME VARCHAR2(128) Global name of the destination database