Re: killing a thread

I don't see an orakill in the $ORACLE_HOME/bin directory for either AIX or SUN at 8.1.6. Are you sure?

Terry

Vadim Gorbounov wrote:

> 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...HTHVadim GorbounovOracle DBA
>
> -----Original Message-----
> From: Kevin Kostyszyn [mailto:kevin_at_dulcian.com]
> Sent: Thursday, April 05, 2001 12:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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, Lisa
> Sent: Thursday, April 05, 2001 12:17 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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_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.
>
> >
> >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
>
> ttp://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: Terry Ball
  INET: terry_ball_at_csgsystems.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).