RE: killing a thread

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Thu, 05 Apr 2001 10:22:19 -0700
Message-ID: <F001.002E2E1A.20010405095248@fatcity.com>

Hi,


It WAS
for windows until 8.1.x, i believe. There is a kill in UNIX, no need for special utility. How to use:

select
spid from v$process, v$session where paddr=addr and sid =
<SID>;

then


orakill <SID> <spid>

thread
will terminate...

HTH
Vadim
Gorbounov
Oracle
DBA



-----Original Message-----From: Kevin Kostyszyn [mailto:kevin_at_dulcian.com]Sent: Thursday, April 05, 2001 12:57 PMTo: Multiple recipients of list ORACLE-LSubject: RE: killing a thread
 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----- >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 > >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 - 12:22:19 CDT