Re: Oracle Sessions

From: Marc Billiet <Marc.Billiet_at_village.uunet.be>
Date: Thu, 27 Aug 1998 21:15:37 +0200
Message-ID: <6s4c14$3f4$1@xenon.inbe.net>

I think userenv('sessionid') doesn't give a correct result when auditing is completely disabled (or v$session.audsid is always 0 in that case, I don't remember exactly what the problem was). I think there was also a problem in procedures and packages executed as a job via dbms_job. Another way is maybe by joining v$session.sid with (select sid from v$mystat where rownum = 1).

Marc Billiet

MarkP28665 wrote in message
<1998082423082800.TAA03395_at_ladder01.news.aol.com>...
>From: proctorh_at_email.exide.com >>
>Is there any way to get information about the session of sqlplus that I am
in?
><<
>
>I do not have the SQL handy to post here at home, but you can join the sid
>returned by the userenv function with the audit sid, audsid, in v$session
to
>get the information you want.
>
>I hope this helps.
>
>Mark Powell -- Oracle 7 Certified DBA
>- The only advice that counts is the advice that you follow so follow your
own
>advice -
>
Received on Thu Aug 27 1998 - 14:15:37 CDT