From kevin@dulcian.com Thu, 05 Apr 2001 09:36:18 -0700 From: "Kevin Kostyszyn" Date: Thu, 05 Apr 2001 09:36:18 -0700 Subject: RE: killing a thread Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: killing a thread I thought that was only for windows machines?  Anyway, how do you use it? Kev -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Koivu, LisaSent: Thursday, April 05, 2001 12:17 PMTo: Multiple recipients of list ORACLE-LSubject: RE: killing a thread I didn't see this in my $ORACLE_HOME/bin.  Is this platform specific? -----Original Message----- From: C.S.Venkata Subramanian [mailto:csvenkata@lycos.com] Sent: Thursday, April 05, 2001 1:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: killing a thread  There is a utility called orakill, this will kill the session. U can find the executable in $ORACLE_HOME/bin directory. This is very useful utility. Try it. -- On Wed, 04 Apr 2001 12:36:08   Kevin Kostyszyn wrote: >did you try alter system kill session immediate? > >-----Original Message----- >Eric >Sent: Wednesday, April 04, 2001 3:11 PM >To: Multiple recipients of list ORACLE-L > > >Is there a way to kill (other than kill session) a thread that is doing an >insert - nologging? > >I have tried "alter system kill session" to no avail.  It gives me the >message >"marked for kill" but the process continues to hang. > >The process has a row exclusive lock with a lock type of TM(dml).  There are >no rows in the table that is being inserted into. > >Any ideas? > >Thanks, >Eric >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Chesebro, Eric >  INET: Eric.Chesebro@apfs.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). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kevin Kostyszyn >  INET: kevin@dulcian.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). > Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian   INET: csvenkata@lycos.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).