CPU skyrockets during contention

From: chuck_forbes <chuck_forbes.26xvp0_at_no-mx.forums.yourdomain.com.au>
Date: Thu, 27 Apr 2006 15:42:57 -0400
Message-ID: <chuck_forbes.26xvp0@no-mx.forums.yourdomain.com.au>

Oracle 10.1.0.3.0
Whenever we see row-level contention, or even today when a table lock caused contention for incoming DML, we see a huge spike in CPU activity (and then our web applications which don't even use these tables start sending timout msgs to our admin).

Why does Oracle penalize the entire system for contention between 2 users, and is this happening because of some configuration we've unknowingly set?

Thanks,
Chuck

-- 
chuck_forbes
------------------------------------------------------------------------
chuck_forbes's Profile: http://www.dbtalk.net/m244
View this thread: http://www.dbtalk.net/t302837

Received on Thu Apr 27 2006 - 14:42:57 CDT