Killing sessions
From: Kimbert Dy NIng <bert_at_admicro.bc.ca>
Date: Sat, 24 Mar 2001 07:48:25 GMT
Message-ID: <djYu6.109161$tP3.1696557_at_news1.rdc1.bc.home.com>
Date: Sat, 24 Mar 2001 07:48:25 GMT
Message-ID: <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
Thanks.
Received on Sat Mar 24 2001 - 08:48:25 CET
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 ??