From: Dick Allie <dallie@ionet.net>
Subject: Re: Determining your own session ID
Date: 1997/04/25
Message-ID: <33610A5F.3EA4@ionet.net>#1/1
References: <3360E241.1AE8@_medicalert.org>
To: trw_@_medicalert.org
Organization: Macklanburg-Duncan
Newsgroups: comp.databases.oracle.server



Tim Witort wrote:
> 
> Is there a way to determine your own session ID in
> a SQL*Plus session?  The key issue I am dealing with
> is a database where the same username may have many
> sessions, so it is not as simple as getting the session
> ID and serial# from v$session where the username is
> my username, because that may return many rows.  I've
> thought about doing a similar select from v$session
> where the COMMAND is a select (since I will be doing
> a select when the data is retrieved), but another
> same-named user may also be doing a select, so that
> only reduces the chances of getting multiple rows back
> but does not eliminate it.
> 
> Any ideas?
> 
> thanks,
> -- TRW
> --
> ||||   remove the underscores in my address to reply   ||||
> |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
> | Tim Witort            ||  He is not silent.  He is not  |
> | trw_@_medicalert.org  ||  whispering.  We are not quiet |
> |                       ||  we are not listening.         |
> | Pin: TZ, only one :^( ||             - Out of the Grey  |
> |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

In unix you can identify the terminal you are connected to. That is in
v$session. and should be unique.
Dick Allie - dallie@ionet.net