RAC CBC Latch
- From: <Ravi_Kulkarni@xxxxxxxx>
- To: <racdba@xxxxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 08:03:51 -0600
List,
Any pointers on how to reduce contention on CBC latch ?
I am seeing sessions waiting on multiple hladdr's too.
Recreate tables with Hi-pctfree helped but need much more fine-tuning.
(app team has been doing their bit on reducing logical reads)
How to surely be able to tell the precise fix is (from where it is
waited on) (increasing hash buckets, moving tables to smaller blocksizes
)
10.1.0.4 (2Node) / RH 3.0.
NoWait
Waiter
Latch Name Where Misses Sleeps
Sleeps
------------------------ -------------------------- ------- ----------
--------
cache buffer handles kcbzfs 0
8 6
cache buffers chains kcbgtcr: kslbegin excl 0 91,563
67,822
cache buffers chains kcbgtcr: fast path 0 57,384
76,694
cache buffers chains kcbrls: kslbegin 0 25,944
31,763
cache buffers chains kcbchg: kslbegin: bufs not 0 942
35
cache buffers chains kcbxbh 0
391 32
cache buffers chains kcbzgb: scan from tail. no 0 101
0
Thanks,
Ravi.
Other related posts:
