Re: Fast roll-back
Date: Sat, 24 Jan 2009 20:07:16 +0000 (UTC)
On Fri, 23 Jan 2009 23:37:30 +0000, Jonathan Lewis wrote:
> 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.
In Oracle8i. Here is the post from Tom Kyte:
and we said...
In Oracle8i PMON defers transaction recovery of "killed" sessions
to SMON which may use fast start parallel rollback if necessary.
This frees up locks held by the killed process immediately. (see that
Note: you should not allow yourself to get into a situation where this is
frequently. Something is really wrong if this is a frequently occurence. This should be
the exception to the rule, not standard operating procedure.
The URL is: