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

Home -> Community -> Usenet -> c.d.o.server -> Re: Dropping user with logged in sessions

Re: Dropping user with logged in sessions

From: gazzag <gareth_at_jamms.org>
Date: 6 Feb 2007 08:13:33 -0800
Message-ID: <1170778413.249600.195470@a34g2000cwb.googlegroups.com> 





On 6 Feb, 15:53, hasta..._at_hotmail.com wrote:


> Is there an upper bound for the time needed

> to actually kill a session at the oracle level ?

>




In my experience, the ALTER SYSTEM KILL SESSION statement will set the
STATUS of the session involved to KILLED.  It may well take some time
before Oracle clears down these sessions, however, a schema with
KILLED sessions can be dropped from the database.



HTH


-g
Received on Tue Feb 06 2007 - 10:13:33 CST












Original text of this message













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