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@xxxxxxxxxxx x72546 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon > Sent: Wednesday, January 10, 2007 11:15 > To: Andrey.Kriushin@xxxxxxxx; 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: -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l