Re: killing sessions in v$session

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 31 Aug 2004 14:20:21 +1000
Message-ID: <4133fc9d$0$7223$afc38c87@news.optusnet.com.au>

yls177 wrote:

> select status, serial#, sid from v$session
>
> get the sid, serial# from v$session
>
> alter system kill session 'sid, serial#';
>
> select status, serial#, sid from v$session but gives the status KILLED
>
>
> I understand that it could be doing rolling back and it could take a
> long time. Hence, i will monitor again and replied later.
>
> Cheers

Sorry... is there actually a question here?

A session will appear killed in V$session until such time as it attempts to perform some new action (such as a select against a table, or a piece of DML). Only at that point does the original session get a 'you've been killed' message, and only then does the session disappear from v$session.

If you want to hurry things along, kill the session as you have done first, and *then* practice your kill -9 skills, assuming you're on Linux or Unix.

Regards
HJR Received on Mon Aug 30 2004 - 23:20:21 CDT