Re: Fast roll-back

From: Michael Austin <>
Date: Fri, 23 Jan 2009 19:52:26 -0600
Message-ID: <Hvuel.11027$>

The Boss wrote:
> Jonathan Lewis wrote:
>> "Mladen Gogala" <> wrote in message
>> news:gldfif$3en$
>>> 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.


> "When you kill a process using alter system kill session then pmon will do
> the rollback/recovery, if instead you kill the OS process smon will do the
> recovery which might look more attractive sometimes since parallel can be
> used. Be aware of 100% CPU usage by smon and his parallel processes though."

Well, this too will depend. There are some really nasty bugs in certain   9i versions that a parallel rollback would hang on a partitioned index locking everything up until it cleared. Received on Fri Jan 23 2009 - 19:52:26 CST

Original text of this message