Re: how to kill a session that marked for kill

From: hans-peter sloot <h.g.sloot_at_ptt-telecom.nl>
Date: 1997/12/02
Message-ID: <01bcfef2$cacb19a0$10d80791@Hans-Peter>#1/1

I think that this session will go away eventually automatically. Probably recovery needs to be done.

Sigrid Staudte <mstaudte_at_rz.uni-leipzig.de> wrote in article <34830B6D.5C2B38E5_at_rz.uni-leipzig.de>...
> In the database a session is running that
> runs and runs and blockade ressources, locks tables
> and so on. The session is never ending.
> It is not possible to kill this session
> with the alter system kill session command. The
> session is only marked for kill. The only way to
> terminate the session is shutting down the database.
> Knows anywhere another way to solve this problem?
>
>
> Bye...Sigrid
>
Received on Tue Dec 02 1997 - 00:00:00 CST