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).
