Re: Fast roll-back

>> "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.

> "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."
> http://www.freelists.org/post/oracle-l/pmon-smon-transaction-recoveryrollback,4
>

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