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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
> >
> >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
