RE: Rollback waiting on 'cache buffer chains' latch

Allen,

I'm afraid there are no good news for you. And I agree with Mark that there is something weird with (latch?) clean up/release. Unfortunately, it's not that easy to catch. And usually the only working drug is to bounce the instance.

And again I'm late - sorry, its about 4 am here is Moscow. Hopefully those guys from OSS asked you to take a couple of systemstate dumps or even "latches" dumps before you managed to bounce the instance. Sorry, the idea of LATCHES dumps came to me too late. It was a chance to see the holder, if the latch was kept permanently (due to failed cleanup or other bug of that sort in another session).

Definitely all that looks like a bug. So be prepared and arm yourself with a list of dumps to take on next occurence. Hopefully, it would not be required then.

Also it is a good idea to ask Tanel or other fellow gurus on the list for a piece of code to monitor the particular latch structure directly in SGA.

--Andrey
PS. Could you, please, share the results of the investigations with the list when it will be resolved? We have a bunch of the customers with critical 24x7 databases which are already on 9.2.0.8 or have plans to patchset-up (is it correct wording?) their production databases to this release.

On Wed, January 10, 2007 02:47, Allen, Brandon wrote:
> Any ideas on how to clear it other than bouncing the instance?

--
http://www.freelists.org/webpage/oracle-l