Re: Help, processes won't die

[Jon Walthour]

Title: Help, processes won't die

Ivan:   The problem is that there is no way to "wake up" PMON. PMON is cleaning up and rolling back all uncommitted transactions every 3 minutes and this isn't configurable. If this is 8i, you could have used alter session ... kill session immediate, although if you've already killed it normally, you can't try to kill it again. Seems the only way to clean it out is to bounce the instance, although that may take time, too.   Just a thought: you could also try, for future reference, setting CLEANUP_ROLLBACK_ENTRIES. It sets how may rollback entries are cleaned up on a single pass. This became a hidden parameter in 8.1.3 and, since I never officially advocate the use of hidden parameters, if you're using 8.1.3 or higher and use it, you're on your own. ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 01, 2001 1:01 PM 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