RE: Help, processes won't die

[Kevin Kostyszyn]

Title: Help, processes won't die

I believe that I read somewhere that issuing a kill session will NOT free up the memory from that session.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 1:02 PM
To: Multiple recipients of list ORACLE-L
Subject: Help, processes won't die

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