Re: session dentification

From: Lowell Paden <Paden_LV_at_nospam.vdot.state.va.us>
Date: Thu, 17 May 2001 08:38:28 -0400
Message-ID: <tvPM6.1$a4.61@dit4.state.va.us>

This will give you your current sessions sid and serial#..

select sid, serial# from v$session where audsid=userenv('sessionid');

"Jörg Bläse" <jb_at_blaese.de> wrote in message news:3b035b4d.1814511719_at_businessnews.de.uu.net...
> Hi,
> I want to mark records with an unique "identifier" which contains
> userid and session, who created/last modified the record.
> I need to know from "outside" (other sessions), whether the modifying
> session is still alive.
>
> The sys_guid() function provides a unique identifier, but how can I
> find out the sessions state from outside?
>
> Is there another possibility?
>
> TIA
> Joerg
Received on Thu May 17 2001 - 07:38:28 CDT