killed session
From: buky <_buky_zg_at_hotmail.com>
Date: Fri, 16 Jan 2004 09:58:03 +0100
Message-ID: <bu892t$1ka$1_at_sunce.iskon.hr>
Date: Fri, 16 Jan 2004 09:58:03 +0100
Message-ID: <bu892t$1ka$1_at_sunce.iskon.hr>
I killed a session on a local database using "alter system kill session" command. But, in v$session, there is still a recordsed with that session, marked as killed (db version 9.2.0.1).
How could I really delete this session, because I think it's causing me some problems?
Also, how could I know which objects (tables, packages) are locked by some session?
tnx in advance Received on Fri Jan 16 2004 - 09:58:03 CET