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

I'm not positive because I wans't actually working on this in the beginning - I jumped in to help my coworker once things got ugly, but according to him, the sequence went like this:

1. deadlock
2. kill session via OEM (I'm assuming this does an 'alter system kill session')
3. alter system kill session via SQL*Plus
4. kill -9 on AIX process

My understanding is that if a process in rollback was killed, PMON would cleanup after it, but either my understanding is correct or maybe there was just some problem/bug in that handoff in this case.

Regards,
Brandon

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel.Patterson_at_crowley.com
Sent: Wednesday, January 10, 2007 6:34 AM To: tanel.poder.003_at_mail.ee; oracle-l_at_freelists.org Subject: RE: Rollback waiting on 'cache buffer chains' latch - SOLVED

Not sure if I followed the steps exactly, so did you issue the kill -9 first? The point being that I believe it is best to kill the oracle session first with alter system -- and background processes can clean up better.

If you did the session first, then disregard.

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Poder Sent: Tuesday, January 09, 2007 10:56 PM To: 'oracle-l'
Subject: RE: Rollback waiting on 'cache buffer chains' latch - SOLVED

Brandon,

did you check v$latchholder for any potential latch holders when you had this issue?

Tanel.

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
> Sent: Wednesday, January 10, 2007 11:15
> To: Andrey.Kriushin_at_rdtex.ru; Bobak, Mark; oracle-l; Mladen Gogala
> Subject: RE: Rollback waiting on 'cache buffer chains' latch - SOLVED
>
> 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:

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


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



Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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