Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing Unique Session ID
Maybe that combination is unique, but knowing the audsid is unique too and increases monotously, I'd rather use the audsid. The audsid is also what is stored in any auditing tables.
Hth,
Sybrand Bakker, Oracle DBA
"John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote in message
news:hTo15.5473$dC.24880_at_typhoon.tampabay.rr.com...
> Do you mean the SID, Serial# combination cannot be used to uniquely
identify
> a session?
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> news:960880949.21754.1.pluto.d4ee154e_at_news.demon.nl...
> > This provides the SID which is *NOT* unique.
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > "John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote in message
> > news:6lf15.6949$ZZ3.18746_at_typhoon.tampabay.rr.com...
> > > 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