Skip to Main Content

Database Software

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!

Contention: latch cache buffers chains

676926Jan 6 2010 — edited Sep 28 2010
Hi all
I am reviewing performance on a busy message queuing system that has hundreds of sessions enqueuing and dequeuing from a single queue table. The top wait event - by a country mile - is latch: cache buffers chains. This wait causes sessions to spin on the CPU while waiting and it results in high server CPU usage. While performance for the AQ database is ok, the high CPU usage caused by the spinning is impacting some other databases. Changing the queue structure of the application (adding more queues) is unlikely.
What other options are available to reduce the impact of sessions attempting to enqueue/dequeue from the same queue table? I cannot find much reference material about high performance AQ configurations. I believe that partitioning the queue table is not possible.




Many thanks!
Mark
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2010
Added on Jan 6 2010
1 comment
2,646 views