Re: Determining your own session ID

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_at_ionet.net Received on Fri Apr 25 1997 - 00:00:00 CDT