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" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
