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 -> Forcing session to disconnect

Forcing session to disconnect

From: Olivier Bercovitz <olivier.bercovitz_at_steria.fr>
Date: Fri, 11 Sep 1998 08:25:22 GMT
Message-ID: <35F8DDFD.54E733DA@steria.fr> 





Hello everybody,



Do you know if there is a way to disconnect (clean) all Oracle sessions
without shutdown an startup the database.
We need to disconnect or kill all the sessions to free all locks so even



for the sessions currently running.


When we try "alter system kill session...." sometime the statement is
locked


so how can we do to free all locks for all the sessions and to be sure
that


all locks are free ??


Thanks in advance



Regards.


Olivier

Received on Fri Sep 11 1998 - 03:25:22 CDT












Original text of this message













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