GV$PROPAGATION_RECEIVER

select
inst_id,                 -- INST_ID NUMBER
kwqpdsqs,                -- SRC_QUEUE_SCHEMA VARCHAR2(30)
kwqpdsqn,                -- SRC_QUEUE_NAME VARCHAR2(30)
kwqpddbn,                -- SRC_DBNAME VARCHAR2(128)
decode                   -- DST_QUEUE_SCHEMA VARCHAR2(30)
  (bitand (max (kwqpdflg), 1), 1, max (kwqpddqs), null),
decode                   -- DST_QUEUE_NAME VARCHAR2(30)
  (bitand (max (kwqpdflg), 1), 1, max (kwqpddqn), null),
min (kwqpdtim),          -- STARTUP_TIME DATE
max (kwqpdhwm),          -- HIGH_WATER_MARK NUMBER
min (kwqpdack),          -- ACKNOWLEDGEMENT NUMBER
max (kwqpdmsg),          -- TOTAL_MSGS 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,
kwqpdsqs,
kwqpdsqn,
kwqpddbn
home |  up  |  mailbox