Re: latch free - cache buffers chain problem

I missed the version in the earlier post. However if this is 8.1.7 this sounds similiar to a problem we had after upgrading to 8.1.7.1. I started a thread on this subject around the end of August (after the 19th).

Our problem was an index root block, turns out Oracle did take it as a bug as the block was pinned many more times than it was under 8.0.6 and has produced a one off patch for us for 8.1.7.2. We have been unable to test it to this point but are scheduled to do so in the next few weeks.

It might be interesting to read that thread and see if anything is similiar.

Scott Gamble

gulab_jaiswal_at_yahoo.com (Gulabchand Jaiswal) wrote in <a562ad94.0110290622.1bea50ce_at_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 - 10:58:57 CST