From carmichr@hotmail.com Wed, 01 Aug 2001 11:02:36 -0700 From: "Rachel Carmichael" Date: Wed, 01 Aug 2001 11:02:36 -0700 Subject: Re: Help, processes won't die Message-ID: MIME-Version: 1.0 Content-Type: text/plain killed processes don't go away immediately, there is cleanup involved. in fact -- does your batch job do updates/inserts without commits? if so, those processes will stay around until the roll back has finished. And bouncing the database won't eliminate the roll back >From: Ivan_Rivera@doh.state.fl.us >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Help, processes won't die >Date: Wed, 01 Aug 2001 09:01:38 -0800 > >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 _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr@hotmail.com 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@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).