GV$PROPAGATION_RECEIVER

select
inst_id,                 -- INST_ID NUMBER
kwqpdsqn,                -- SRC_QUEUE_NAME VARCHAR2(66)
kwqpddbn,                -- SRC_DBNAME VARCHAR2(128)
min (kwqpdtim),          -- STARTUP_TIME DATE
max (kwqpdhwm),          -- HIGH_WATER_MARK NUMBER
min (kwqpdack),          -- ACKNOWLEDGEMENT NUMBER
min (kwqpdupc),          -- ELAPSED_UNPICKLE_TIME NUMBER
min (kwqpdrul),          -- ELAPSED_RULE_TIME NUMBER
min                      -- ELAPSED_ENQUEUE_TIME NUMBER
  (kwqpdenq) - min (kwqpdupc) - min (kwqpdrul) 
from
x$kwqpd 
group by inst_id,
kwqpdsqn,
kwqpddbn
home |  up  |  mailbox