GV$PROPAGATION_SENDER definition in Oracle Database 10.2 / www.oracledba.ru
GV$PROPAGATION_SENDER
select
s.inst_id, -- INST_ID NUMBER
s.kwqpsqid, -- QUEUE_ID NUMBER
q.queue_schema, -- QUEUE_SCHEMA VARCHAR2(30)
q.queue_name, -- QUEUE_NAME VARCHAR2(30)
s.kwqpsdqs, -- DST_QUEUE_SCHEMA VARCHAR2(30)
s.kwqpsdqn, -- DST_QUEUE_NAME VARCHAR2(30)
s.kwqpstim, -- STARTUP_TIME DATE
s.kwqpsdbn, -- DBLINK VARCHAR2(128)
s.kwqpshwm, -- HIGH_WATER_MARK NUMBER
s.kwqpsack, -- ACKNOWLEDGEMENT NUMBER
s.kwqpsstt, -- SCHEDULE_STATUS VARCHAR2(30)
s.kwqpsmsg, -- TOTAL_MSGS NUMBER
s.kwqpsbyt, -- TOTAL_BYTES NUMBER
s.kwqpsdeq, -- ELAPSED_DEQUEUE_TIME NUMBER
s.kwqpspic, -- ELAPSED_PICKLE_TIME NUMBER
s.kwqpsprp -- ELAPSED_PROPAGATION_TIME NUMBER
- s.kwqpsdeq - s.kwqpspic,
s.kwqpsmmsg, -- MAX_NUM_PER_WIN NUMBER
s.kwqpsmbyt -- MAX_SIZE NUMBER
from
x$kwqps s,
x$buffered_queues q
where
s.inst_id = q.inst_id and s.kwqpsqid = q.queue_id and bitand (q.flags, 16) = 0