Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback waiting on 'cache buffer chains' latch (doh.)

RE: Rollback waiting on 'cache buffer chains' latch (doh.)

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 10 Jan 2007 09:13:13 -0500
Message-ID: <FBEIIHEAOIFCBBNIIFOGEEONCJAA.mwf@rsiz.com>


Glad to see it is solved.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mark W. Farnham
Sent: Wednesday, January 10, 2007 8:51 AM To: Brandon.Allen_at_OneNeck.com; rstauffer_at_decommunications.com; oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 10 2007 - 08:13:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US