Oracle AQ – 为什么我在全局视图中看不到处理的消息?
有没有人有一个想法,为什么我看到PROCESSED消息在这里: select 'MFS_MISSION' as queue_name, CONSUMER_NAME, MSG_STATE, count(*) from aq$MFS_MISSION_QTAB group by consumer_name, MSG_STATE QUEUE_NAME CONSUMER_NAME MSG_STATE COUNT(*) ————- —————- ———— ———– MFS_MISSION T1 PROCESSED 143216 MFS_MISSION S1 PROCESSED 377208 但不在这里: select dq.queue_table, dq.queue_type, dq.name, v$aq.waiting, V$AQ.ready, V$AQ.expired, V$AQ.total_wait, V$AQ.average_wait from V$AQ, dba_queues dq where dq.qid=v$aq.qid and dq.name like '%MISSION%' QUEUE_TABLE QUEUE_TYPE NAME WAITING READY […]