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

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