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 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
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)
ELAPSED_RULE_TIME NUMBER Elapsed rule 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
SESSION_ID NUMBER Session ID of the propagation sender process
SERIAL# NUMBER Serial number of the propagation sender process
SPID VARCHAR2(24) Process identification number of the propagation sender process
PROPAGATION_NAME VARCHAR2(30) Name of the Streams propagation
STATE VARCHAR2(53) State of the propagation sender process:
  • Initializing

  • Initializing propagation receiver

  • Browsing LCRs

  • Evaluating rules

  • Dequeueing LCRs

  • Sending LCRs

  • Waiting for apply to be enabled

  • Waiting for apply database to start

  • Waiting for propagation to be enabled

  • Waiting for capture to terminate

  • Waiting for a subscriber to be added

  • Suspended due to a dropped subscriber

  • Suspended for auto split/merge

  • Waiting on empty queue

When the SCHEDULE_STATUS column is not SCHEDULE OPTIMIZED, the state is the value of the SCHEDULE_STATUS column.