Re: latch free - cache buffers chain problem

From: Gulabchand Jaiswal <gulab_jaiswal_at_yahoo.com>
Date: 29 Oct 2001 06:22:03 -0800
Message-ID: <a562ad94.0110290622.1bea50ce@posting.google.com>

oraperf_at_yahoo.com (Kyle Hailey) wrote in message news:<3bd85efa.93575314_at_newsfeeds-goliath.1usenet.net>...
> But the main cause of waits on the cache buffers chains latch comes
> from users reading and writing the same block in and inefficient way.
> If writers don?t commit their changes immediately, then readers who

..................snip............................

> Comments appreciated
>
> Best Wishes
> Kyle Hailey

 oraperf.sourceforge.net

Kyle,
Thx for an excellent amd insightful response and Thanks to all those who responded. We are getting there. The contention is on block in an index ! We recreated it more pctfree ( thx jonathan) and need to run more tests. Will keep you guys posted how results turn out..

Thx again Received on Mon Oct 29 2001 - 08:22:03 CST