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

Yes. It would help to know the steps.
  Sometimes if we kill at sqlplus level using alter system it is not possible to get the corresponding OS session and it keeps hanging in 'KILLED' status. Is that what happened or did it hang even after you did    

1. kill at oracle sqlplus level using alter system
2. kill at OS level using kill -9 and even after that you had to do a bounce.

  I think it is better to get the OS session id and save it before doing the alter system at sqlplus level. I think kill at OS level was suggested by Stauffer, Robert early on.    

  Another question would be : was this KILLED session being locked out by some other session? Was that checked? I know the wait event was 'cache buffer chains' but just asking if you checked if .    

  Can you share the details for our benefit. Thanks   

Joel.Patterson_at_crowley.com wrote:
  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




 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l