Re: Forcing session to disconnect

From: Reid Lai <reidlai_at_hk.super.net>
Date: Fri, 11 Sep 1998 20:19:04 +0800
Message-ID: <35F91538.828042BA@hk.super.net>

Use ALTER SYSTEM KILL SESSION.

Olivier Bercovitz wrote:

> 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 - 07:19:04 CDT