RE: Rollback waiting on 'cache buffer chains' latch (doh.)
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <mwf@xxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>, <rstauffer@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Jan 2007 09:13:13 -0500
Glad to see it is solved.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Mark W. Farnham
Sent: Wednesday, January 10, 2007 8:51 AM
To: Brandon.Allen@xxxxxxxxxxx; rstauffer@xxxxxxxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: Rollback waiting on 'cache buffer chains' latch
Did you ever get a solution?
<snip>
doh. I need to remember to pull new messages before I respond to the thread
from the night before...
Anyway, on instance restarts Oracle gets the luxury of processing redo and
rollbacks in the most effective order. Unlikely you'll ever find the true
root cause at this point, though I would still avoid killing processes
already in rollback unless there is evidence the process running away doing
something pathological like trying to talk to a coprocess that isn't there
any longer. Rollbacks really must complete.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: Rollback waiting on 'cache buffer chains' latch (doh.)
