Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: pmon & smon transaction recovery/rollback

Re: pmon & smon transaction recovery/rollback

From: amonte <ax.mount_at_gmail.com>
Date: Wed, 31 Jan 2007 16:09:19 +0100
Message-ID: <85c1fb130701310709v3cc8a1emdffd35952cdf1837@mail.gmail.com>


yes, I think you mean setting event 10513 to level 2, however my question is, isnt that really a pmon's job?

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
Received on Wed Jan 31 2007 - 09:09:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US