Re: Fast roll-back
Date: Fri, 23 Jan 2009 23:37:30 -0000
"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message
> On Fri, 23 Jan 2009 12:33:36 +0000, Jonathan Lewis wrote:
>> If the session is killed or the database is restarted (before the
>> process commits its transaction) then smon handles the rollback.
> I am humbled. My mentioning of PMON was a honest mistake, caused
> by the aforementioned root canal.
I hadn't noticed that you'd said pmon instead of smon.
I have a feeling that there was a time when pmon was the process that did the rollback if a user process crashed - but I don't recall when it could have changed.
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Fri Jan 23 2009 - 17:37:30 CST