Re: User list of current logon to Oracle

Hi Yu Jie!

As it was urgent I'll just mention v$session, that view may be what you're looking for.
Haven't really dug into it, and it was a while since I used that and other system views.

Regards,

    Birger Johansson

In article <8dejk2$cgs$1_at_mango.singnet.com.sg>,   "Yu Jie" <dds006_at_singnet.com.sg> wrote:
> 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
>
>

--
---------------------------------------------
Birger Johansson
Ibitec Datakonsult AB           www.ibitec.se
---------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.