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
