Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help, processes won't die
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).Received on Wed Aug 01 2001 - 12:53:51 CDT