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

Hello,

 

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,

Nicholas

Actions