Oracle MVA

Tales from a Jack of all trades

Archive for February 2010

Contention problems with AQ

with 4 comments

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:

Read the rest of this entry »

Advertisements

Written by Jacco H. Landlust

February 26, 2010 at 10:11 am

Posted in RAC, RDBMS

New paper at Method-R

leave a comment »

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!

Written by Jacco H. Landlust

February 16, 2010 at 11:09 pm

Posted in Announcements