Re: Unique identifier for the session.

I use instance manager (the enterprise manager package for Windows). At the session tab, I can see what application that user is running and their corresponding information. You can also kill the session in instance manager by clicking on the corresponding session

Winnie

Asif H. rajwani wrote in message <359D5BE4.55B93F30_at_mci2000.com>...
>Hi,
> I want to get the unique identifier for the sesssion.
>I tried gettting session id using this query:
>
> select sid, username, user#, type from v$session where username =
> USER
>
> But it gives me multiple sid if the user is logon from more than one
> location or has multiple session on the same machine.
>
> Is there any way to get the identifier which is unique to a session.
>
> Thanks.
>
> Asif
> ===
>
Received on Mon Jul 06 1998 - 00:00:00 CDT