Contention problems with AQ

While doing a routine checkup I found that four processes are eating up CPU’s on one node of a two (2) node RAC cluster. These processes are ora_q000_SID2, ora_Q001_SID2, ora_Q002_SID2 & ora_Q003_SID2. This suggests there is some extra activity with AQ on the SID2 instance. (This is a 10.2.0.4 RDBMS RAC running on 64-bit OEL 4.7, CRS and ASM on 11.1.0.7)

So first thing I investigated were the queues:

New paper at Method-R

Cary Millsap announced that he published a new paper called “Thinking clearly about performance”. I am not that much of a “plugger”, but I really really advise everyone that has to work with Oracle to read the paper. (an no, I’m not sucking up). Especially the qualification of performance as a feature is an interesting insight which I most likely will reproduce to some people.

Thanks Cary!