Re: 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. <BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A title=Ivan_Rivera_at_doh.state.fl.us href="mailto:Ivan_Rivera_at_doh.state.fl.us">Ivan_Rivera_at_doh.state.fl.us

  To: <A title=ORACLE-L_at_fatcity.com
  href="mailto:ORACLE-L_at_fatcity.com">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 Received on Wed Aug 01 2001 - 12:07:28 CDT