Re: Killing sessions
Date: Tue, 27 Mar 2001 15:21:02 +0200
Message-ID: <99q43n$ck6$1_at_mail.ic.uva.nl>
Hi,
Sometimes one has to not only kill the session within Oracle, but also the session on OS level.
Roelof
"Kimbert Dy NIng" <bert_at_admicro.bc.ca> schreef in bericht
news:djYu6.109161$tP3.1696557_at_news1.rdc1.bc.home.com...
> When I check GV_$LOCKED_OBJECT, I can see that my process xx of session
ID
> yy is locking my table. Given my SID, and SERIAL#, I try to kill that
> session (using ALTER system kill SESSION SID, SERIAL#)
> I can see that it is marked as killed but in my GV_$LOCKED_OBJECT, I can
> still that
> it is still there. I'm guessing that even though I have killed the
session,
> the resources/locks has not been released yet. Is there a way to force the
> release of my resource or table lock immediately ??
>
> Thanks.
>
>
Received on Tue Mar 27 2001 - 15:21:02 CEST