Re: "buffer cache handle" latch with high sleep time

fuocor_at_novachem.com wrote:
>
> we are seeing very high sleep times for the "buffer cache handle"
> latch in our oracle 7.1.4 production system. Can anyone recommend any
> course of action to reduce the sleep time. Thanks

  Tune the SPIN_COUNT parameter.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.