Re: Killing V2 connections from client

SGhosh007 wrote:
>
> 1. In sqldba i see processes locking tables however i have killed these
> processes. these are connections using V2 and MTS so there is no unix
> process to kill (like we could in V1 by finding the T: in ps -aef ) . Is
> there any solution to this.
>
> thanks
>
> soumitra

Oracle7 SQL Reference, Release 7.2, page 4-82 shows.....

     select sid, serial#, username from v$session;
     alter system kill session 'sid,serial#';

.....and it works fine, maybe better than "kill -9" which is so harsh.

brian.maclean_at_teldta.com

Measure with a micrometer. Mark with chalk. Cut with an axe. Received on Thu Apr 18 1996 - 00:00:00 CEST