RE: killing a thread

Hi!

ORAKILL is only available on Windows NT/2000. Because Oracle uses a thread based architecture on Windows and all threads run within the same "oracle.exe".

On UNIX, Oracle is process based and you can kill the corresponding process.

hth,
Helmut

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gene Sais
> Sent: Thursday, April 05, 2001 02:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: killing a thread
>
>
> I can't find it either. Is the script you meant?
>
> $ORACLE_HOME/network/agent/jobs/oracle/cmanager/general/killsess.tcl
>
> >>> lkoivu_at_qode.com 04/05/01 12:16PM >>>
> I didn't see this in my $ORACLE_HOME/bin. Is this platform specific?
>
> -----Original Message-----
> Sent: Thursday, April 05, 2001 1:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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_at_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_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: 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
> >--------------------------------------------------------------------
> >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
> 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_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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.us
>
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.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).