Event Wait Streams AQ
Dear Sir,
we have oracle database 10.2.0.5 with operation system linux OEL5,
we are not using Advanced Queuing,
so why we have the following wait ?!!
SELECT event, state, COUNT(*) AS cnt, sum(seconds_in_wait) AS wait_in_seconds
FROM v$session_wait
WHERE event LIKE 'Streams AQ%'
GROUP BY event, state;
EVENT STATE CNT WAIT_IN_SECONDS
1 Streams AQ: qmn slave idle wait WAITING 1 2190844
2 Streams AQ: waiting for time management or cleanup tasks WAITING 1 2242447
3 Streams AQ: qmn coordinator idle wait WAITING 1 857137
P.S. aq_tm_processes = 0
Regards,