Streams queued message count going up, transactions being processed
edited Feb 17, 2010 10:26PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
We have Oracle 9i running with Streams between 2 databases. It has been running but now the message count keeps increasing although the transactions are being processed. The aq_tm_processes = 3 , the health check scripts look OK. Any hints?
select
max
(bufqm_nmsg),
r.status
from dba_queues q, dba_capture r, sys .v_$bufqm
where q.owner = r.queue_owner
and q. name = r.queue_name
and bufqm_qid = q.qid
group by r.queue_name, r.queue_owner, q.queue_table, q.qid, r.status max (bufqm_nmsg),
r.status
from dba_queues q, dba_capture r, sys .v_$bufqm
r.status
from dba_queues q, dba_capture r, sys .v_$bufqm
where q.owner = r.queue_owner
and q. name = r.queue_name
and bufqm_qid = q.qid
group by r.queue_name, r.queue_owner, q.queue_table, q.qid, r.status max (bufqm_nmsg),
r.status
from dba_queues q, dba_capture r, sys .v_$bufqm
0