Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Row cache lock tuning
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