11 Replies Latest reply: Mar 18, 2010 9:27 AM by Fidel Vales RSS

Streams AQ wait event on Oracle 10g

Nicholas Bourgon
Currently Being Moderated



I have ECC 6.0 on W2k3 with Oracle. I have some wait event about Streams AQ :


Streams AQ: waiting for messages in the queue

Streams AQ: qmn slave idle wait

Streams AQ: qmn coordinator waiting for slave to start


What does it mean ? What can I do to fix that?


From what I read, it's seems to have something to do with parameter : aq_tm_processes


What this parameter whould be set to? It seems to be set to O now.


Thank you for any help,