Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> killed session

killed session

From: buky <_buky_zg_at_hotmail.com>
Date: Fri, 16 Jan 2004 09:58:03 +0100
Message-ID: <bu892t$1ka$1@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 - 02:58:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US