Re: session dentification

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 16 May 2001 22:24:43 -0700
Message-ID: <3B03609B.E3927ECF@exesolutions.com>

"Jörg Bläse" wrote:

> 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

Outside what?

Session information is available in v$session.

Daniel A. Morgan Received on Thu May 17 2001 - 00:24:43 CDT