Re: Fast roll-back
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 23 Jan 2009 23:37:30 -0000
Message-ID: <yYednRTV1PYkyefUnZ2dnUVZ8qTinZ2d_at_bt.com>
Date: Fri, 23 Jan 2009 23:37:30 -0000
Message-ID: <yYednRTV1PYkyefUnZ2dnUVZ8qTinZ2d_at_bt.com>
"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message
news:gldfif$3en$1_at_ss408.t-com.hr...
> 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.
>
Mladen,
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