RE: killing a thread

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Thu, 05 Apr 2001 09:36:18 -0700
Message-ID: <F001.002E2B43.20010405085646@fatcity.com>

I
thought that was only for windows machines? Anyway, how do you use it?
Kev

-----Original Message-----From: root_at_fatcity.com [mailto:root_at_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 [<A
 href="mailto:csvenkata_at_lycos.com">mailto:csvenkata_at_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----- <FONT

 size=2>>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. > <FONT

  size=2>>Any ideas? > <FONT 
  size=2>>Thanks, >Eric <FONT 
  size=2>>-- >Please see the official ORACLE-L

FAQ: <A target=_blank
 href="http://www.orafaq.com">http://www.orafaq.com >-- >Author: Chesebro, Eric
> INET: Eric.Chesebro_at_apfs.com <FONT
 size=2>> >Fat City Network
 Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego,

 California -- Public Internet access / Mailing Lists <FONT

  size=2>>--------------------------------------------------------------------

>To REMOVE yourself from this mailing list, send an E-Mail
 message >to: ListGuru_at_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: <A
 target=_blank href="http://www.orafaq.com">http://www.orafaq.com
>-- >Author: Kevin

 Kostyszyn > INET: kevin_at_dulcian.com
> >Fat City Network

 Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego,

 California -- Public Internet access / Mailing Lists <FONT

  size=2>>--------------------------------------------------------------------

>To REMOVE yourself from this mailing list, send an E-Mail
 message >to: ListGuru_at_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 <A target=_blank
 href="http://mail.lycos.com/freemail/vistaprint_index.html">http://mail.lycos.com/freemail/vistaprint_index.html

Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata_at_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_at_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).

Received on Thu Apr 05 2001 - 11:36:18 CDT