Re: Dropping Users That Are Currently Connected / Killing Sessions

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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Tue Jun 29 2004 - 03:16:02 CDT