Re: Rollback waiting on 'cache buffer chains' latch

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 10 Jan 2007 09:59:57 -0800
Message-ID: <bf46380701100959y5621f1f6h66cd1986b596a933@mail.gmail.com>

On 1/9/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Thanks everyone for your help. The only solution we could find, along
> with Oracle Support, was to bounce the instance and luckily it came back
> up with no problems. We don't have any solid root cause yet, but just a
> few possibly related factors to keep in mind:
>
> o We just upgraded to 9.2.0.8 a couple months ago (never had
> this problem on 9.2.0.4)
>

This is not new.

I've encountered this as far back as 7.0.x.

No root cause is ever found as we have never been able to reproduce this. Normally it only happens very infrequently.

The solution has always been:

kill -9 PID
kill the session
if that doesn't work, shutdown abort and restart.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Wed Jan 10 2007 - 11:59:57 CST

Re: Rollback waiting on 'cache buffer chains' latch - SOLVED