Re: pmon & smon transaction recovery/rollback

Hi

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.





On 1/31/07, Kevin Lidh <kevin.lidh@xxxxxxxxx> wrote:


A long time ago on a database far, far away, we killed a process which
was in the process of consuming a large amount of temp and SMON worked
for hours on that tablespace.  We actually had to set an event to
"pause" SMON until we had the time to allow TEMP to be cleaned up.

On Wed, 2007-01-31 at 12:53 +0100, amonte wrote:
> Hi
>
> I have a basic question, we all know that pmon's task is to cleanup
> resource by failed processes such as rolling back transaction,
> releasing locks and resources etc. We also know that smon rolls back
> uncommited transactions after instance failure.
>
> My question is, I killed a couple of processes this morning and smon
> went crazy performing parallel recovery, I was wondering shouldnt that
> pmon's job? There was no instance failure.
>
> TIA
>
> Alex
>

--
http://www.freelists.org/webpage/oracle-l

Other related posts: