Re: Forcing session to disconnect

Hi,

alter system kill session is the only way but doesn't work as you would like

because Oracle refuses to kill sessions that are in the middle of transactions etc..
What it does do, is mark them for kill so they'll be killed asap.

Jeroen

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 Sat Sep 12 1998 - 07:06:28 CDT