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_at_gmail.com> 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
>
>
>

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