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.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 
from
x$kwqps s,
x$buffered_queues q 
where
s.inst_id = q.inst_id and s.kwqpsqid = q.queue_id
home |  up  |  mailbox