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
home |  up  |  mailbox