Re: kill session actually nicely ask for suicide ...

kill on os level

select p.spid
from v$process p, v$session s
where s.paddr = p.addr
and s.sid = &1

sessions also usually stick around to roll back xactions.

On Wed, 10 Dec 2003 12:13:05 +0100, "Giovanni Azua" <bravegag_at_hotmail.com> wrote:

>Hello all,
>
>Is there really a way to KILL!!!! a session
>because the "marked for kill" can easily last
>couple of days, this thing is irritating being
>not preemptive at all.
>
>Best Regards,
>Giovanni
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Dec 10 2003 - 10:57:13 CST