Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing Unique Session ID
This will give you the session_id:
select sid,serial#,username,osuser
from v$session
where audsid = userenv('SESSIONID');
Mary <mdellamalva_at_cetec.com> wrote in message
news:8i3re1$9v8_at_journal.concentric.net...
> Hello Everyone,
>
> I need to access the unique session id for each and every session that
> connects to my Oracle (7.3.4) Database at the time of connection. I have
> been trying to tap into the DBMS_Session function: unique_session_id,
> however it does not appear to have the pragma restrict_references set. I
> keep getting the following ORA Error: ORA-06571: Function
UNIQUE_SESSION_ID
> does not guarantee not to update database.
>
> Does anyone know how to set the pragma restrict_references for this built
in
> function external to the function itself? Or, is there another way of
> accessing the unique sessionid for a specific connection without
referencing
> the userid which will remain the same for multiple connections?
>
> Any help would be appreciated
>
> Mary
> mdellamalva_at_cetec.com
>
>
>
>
>
>
>
>
Received on Tue Jun 13 2000 - 00:00:00 CDT