gt; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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_HO
I can't find it either. Is the script you meant?
$ORACLE_HOME/network/agent/jobs/oracle/cmanager/general/killsess.tcl
>>> [EMAIL PROTECTED] 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
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 Koiv
Title: RE: killing a thread
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 =
;
then
orakill
thread
will terminate...
HTH
Vadim
Gorbounov
Title: 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, LisaSent:
Thursday, April 05, 2001 12:17 PMTo: Multiple recipients of list
Title: 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 t
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-
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 sessi
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). Th