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