Re: Dropping Users That Are Currently Connected / Killing Sessions

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Tue, 29 Jun 2004 20:15:52 +0100
Message-ID: <f6kEc.92$985.52@newsfe6-gui.server.ntli.net>

"Bagieta" <bagieta21_at_poczta.onet.pl> wrote in message news:cbr8p6$e9r$1_at_news.onet.pl...
> select sid, serial# serial, machine, program, username, status,
logon_time,
> lockwait
> from v$session a
> where username is not null
> order by sid
>
>
> then
>
>
> alter system kill session 'SID, SERIAL'
>
>
> Regards
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> dbDeveloper - Multiple databases editor
>
> http://prominentus.com
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
>

thats what i said Received on Tue Jun 29 2004 - 14:15:52 CDT