Re: Forcing session to disconnect

From: Jens Kieffer-Olsen <dstdba_at_post4.tele.dk>
Date: Thu, 17 Sep 1998 10:10:46 +0200
Message-ID: <6tqgta$pdq$2@dalen.get2net.dk>

Olivier Bercovitz wrote in message <35F8DDFD.54E733DA_at_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

From 7.3.4 onwards a special utility called ORAKILL is available.

--
Jens Kieffer-Olsen Received on Thu Sep 17 1998 - 03:10:46 CDT