Re: Determining your own session ID

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/04/25
Message-ID: <33651a91.26406290@newshost>#1/1

Try:

select * from v$session where audsid = userenv( 'sessionid' ) /

That'll get all the session information for you about your currently logged in session.

On Fri, 25 Apr 1997 14:47:43 -0500, Dick Allie <dallie_at_ionet.net> wrote:

>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
[snip]

>>
>> 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 |

[snip]

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

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Apr 25 1997 - 00:00:00 CDT