Re: Latch Contention on cache buffers lru chain

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/02/27
Message-ID: <5f4hh6$3t1@gw.PacBell.COM>#1/1

> When we upreved a couple of our instances from 7.1.4 to 7.1.6, we
> immediately noticed an increase in the number of sleeps and latchwaits
> when Oracle tries to aquire a latch on the cache buffers lru chain.
> A parameter (spin_count) has helped alleviate some but not all
> of the enormous performance degradation we now see. Any insight/feedback
> would be appreciated. Reply to bill_sidloski_at_dg.com

upgrade to 7.3, which includes a new init.ora param to set up multiple latches for the lru.

Johnny Chan
Independent Oracle Specialist Received on Thu Feb 27 1997 - 00:00:00 CST