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