Re: How to kill connection?

From: FaheemRao <faheemrao_at_yahoo.com>
Date: 19 Oct 2001 16:35:15 -0700
Message-ID: <43b58913.0110191535.2a9fcdf7_at_posting.google.com>


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 Sat Oct 20 2001 - 01:35:15 CEST

Original text of this message