Archived discussions are read-only. Learn more about SAP Q&A

Streams AQ wait event on Oracle 10g

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

  • SAP Employee
replied

Hi,

You are correct, I was mistaken with the SAP version

There you "should" see only non idle events.

BUT, the idle events are defined on the "local" table ora_idle_Events

And, in order to have them current you must apply the support packages mentioned on the note 1176846.

On that table the following events are defined as "idle":

Streams AQ: RAC qmn coordinator idle wait

Streams AQ: deallocate messages from Streams Pool

Streams AQ: delete acknowledged messages

Streams AQ: qmn coordinator idle wait

Streams AQ: qmn slave idle wait

Streams AQ: waiting for messages in the queue

Streams AQ: waiting for time management or cleanup tasks

Streams fetch slave: waiting for txns

Review the mentioned note.

If you do not use "streams" then you do not need to worry about them, they are idle.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question