Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Row cache lock tuning

Row cache lock tuning

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 18 Mar 2002 17:50:36 +0000 (GMT)
Message-ID: <anB*7Oyjp@news.chiark.greenend.org.uk>


Oracle 8.1.7.3.0 on HP-UX 11i, single instance, not OPS

I have an instance running a batch process, it's fairly busy (steady thirty megabytes per second redo generated), the top wait event is "row cache lock" wait taking over 50% of the wait time. I've looked around in the usual places, and found good descriptions of what it is, but not what to do about it.

There's plenty of spare CPU capacity and disk bandwidth, library cache hit is 100%, buffer cache 99.7%. Application is Pro*C and using bind variables everywhere. This should be able to go faster.

Is there any knob to tweak?

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Mon Mar 18 2002 - 11:50:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US