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 (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
SESSION_ID NUMBER In combined capture and apply mode, the session ID of the capture process
SERIAL# NUMBER In combined capture and apply mode, the serial number of the capture process
SPID VARCHAR2(24) In combined capture and apply mode, the process identification number of the capture process
PROPAGATION_NAME VARCHAR2(30) Name of the Streams propagation
STATE VARCHAR2(35) In combined capture and apply mode, the state of the capture process:
  • Initializing

  • Capturing change records

  • Evaluating rules

  • Enqueueing LCRs

  • Shutting down

  • Aborting

  • Creating LCRs

  • Waiting for dictionary dump

  • Waiting for redo log

  • Pausing for flow control

  • Processing dictionary dump

  • Waiting for apply to start

  • Waiting for apply database to start

  • Waiting for propagation to start

  • Initializing

  • Initializing propagation receiver

  • Browsing LCRs

  • Evaluating rules

  • Dequeueing LCRs

  • Sending LCRs

  • Waiting for apply to start

  • Waiting for apply database to start

  • Waiting for propagation to start

  • Waiting for capture to terminate

In non-combined capture and apply mode, the state is the value of the SCHEDULE_STATUS column