Re: Unique identifier for the session.

Unique for user session are SID, SERIAL#. Please use select sid, serial#, username type from v$session where username = USER; If you want kill session type ALTER SYSTEM KILL SESSION SID, SERIAL#; or use enterprice manager.

Rafal

In article <6ns4k9$d5b_at_sjx-ixn2.ix.netcom.com>,   "Winnie Liu" <poohland_at_hotmail.com> wrote:
>
> 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
> > ===
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 08 1998 - 00:00:00 CDT