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_at_no-mx.forums.yourdomain.com.au>
Date: Thu, 27 Apr 2006 15:42:57 -0400
Message-ID: <chuck_forbes.26xvp0_at_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/t302837Received on Thu Apr 27 2006 - 21:42:57 CEST