Re: How to kill connection?

try this

alter system kill session '<SID>,<Serial#>'

you can find out sid(session ID ) and Serail Number from V$session

Faheem Rao

"ObloMishka" <Mishka_at_tut.by> wrote in message news:<9qp08s$lm16_at_hu5.hofstra.edu>...
> Hello
> I have DB on the machine with Oracle 8.05 server. And I have installed
> Oracle 8.i server on the other machine. How I can kill connection to this DB
> for single user from machine with Oracle 8.i, if I have all required
> passwords? Which components ans services must be installed for it? (on the
> NT platform)
>
> I hope, that somebody help me,
> thank you all in advance...
Received on Fri Oct 19 2001 - 18:35:15 CDT