Re: Help, processes won't die

Ruth:

Just a couple of notes: first, PMON, not SMON, is responsible for process cleanup--clean up of the components of failed transactions such as cache entries, locks and other process resources. In instance recovery, PMON will rollback any uncommitted transactions. On the other hand, SMON recovers temporary segment space when it's no longer needed, coalesces contiguous areas of free space in database tablespaces where PCTINCREASE is greater than zero, and recovers dead transactions skipped during crash and instance recovery because of file-read or offline errors, which are eventually recovered by SMON when the tablespace or file is brought back online. So, PMON is the instance process needed in this situation.

Second, if Ivan were to perform a shutdown abort in this situation, it would bring the instance down real fast, that's true. However, startup would take that much longer and would require recovery of the database and transactions could be lost. I would not recommend a shutdown abort except as a last resort.

Hope this helps.

Jon Walthour
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 01, 2001 3:06 PM

> It is smon who takes care of cleaning up after killed jobs. You can pay
him
> now or pay him later as the metaphor is mixed but you will have to let him
> do his job. You can try a shutdown abort and startup but they smon will
do
> the cleanup in the background while your users scream.
>
> So, Kim is right. You have to let smon do his thing.
> HTH,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, August 01, 2001 1:56 PM
>
>
> > It could be rolling back. If so, you really do have to wait.
> >
> > -----Original Message-----
> > Sent: Wednesday, August 01, 2001 10:02 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > I need some assistance ASAP. Our nightly batch process seems to have
hung
> > up for some strange reason (ok no biggie my boss says kill it and start
it
> > again). The problem is I have killed the processes both in oracle (sid,
> > serial#) and also in unix. Now I can't see the processes in unix but in
> > oracle they have a status of killed but are still holding the resources.
> My
> > thinking is telling me the pmon is not waking up or not doing it's job.
> How
> > can one manually tell a process to wake up. Any help will be greatly
> > appreciated.
> >
> > OS Solaris 7
> > Oracle 8.0.6.3
> >
> > Thanks. Ivan
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: jonw_at_fuse.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).