Re: User list of current logon to Oracle

I have a similar problem at times

The script I use to generate the statement needed comes from this SQL - hope it helps

select 'alter system kill session ''' || sid || ',' || serial# || ''';' cmd from v$session
where username = upper( '&user' );

Yu Jie <dds006_at_singnet.com.sg> wrote in message news:8dejk2$cgs$1_at_mango.singnet.com.sg...
> Hi, All
>
> I have to know all of the user current logon to Oracle server.
>
> Sometimes, our user logon to Oracle server to do some thing, but
 system(PC)
> hang on the half way. The user press "CTRL+Alt+Del" to munually kill the
> precess. The session should be killed after that. But it still exist in
> top-session(Enterprise Manager).Now we have to know which session acuatlly
> had been killed already. Is there any way to get this information?
>
> We are using Oracle 7.3.4 and HP unix.
> The sys_context doesn't work.
>
> It's very urgent!
>
> thanks
>
> Yu Jie
>
>
>
Received on Fri Apr 21 2000 - 00:00:00 CEST