Re: Forcing session to disconnect

Thanks for your answers,
I will try all that, but I think I cannot have a solution which work in all cases, especially when I have a transaction working.... because after killing all the sessions (with alter system..) we have to kill (unix kill) all the processes except Oracle instance, to switch application server
But never mind thanks again

Regards.
Olivier

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 Tue Sep 15 1998 - 03:06:50 CDT