Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to solve latch: parallel query alloc buffer and Streams AQ: enqueue blocked on

LauryMay 6 2015 — edited May 8 2015


Hi,

Can someone explain me what is the relation between "latch: parallel query alloc buffer" en "Streams AQ: enqueue blocked on" wait event?

I am in a situation for which I have an unexpected Wait Avg in a given database.

Does ssomene has nay tip to solve it?

Thanks by advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2015
Added on May 6 2015
6 comments
1,986 views