Re: Using AUDSID to identify a session

It is also the case that all parallel query slaves acquired by a session generate sessions that clone the audsid - this is not a problem for gathering total stats, but if you write a piece of code that expects just one row of v$session to return against an audsid, then it could fail

    (e.g. in mid pl/sql

        select sid into m_sid
        where audsid = userenv('sessionid');

    Exception - too many rows on single row select.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Sybrand Bakker wrote in message
<929987314.22558.0.pluto.d4ee154e_at_news.demon.nl>...
>Regrettably this isn't for 100 percent true, and I only just hit it last
>week (in 7.3.4)
>Oracle jobs, run by the SNPx process dont' have an audsid. This was the
>reason why our checks failed. Basically it was used to retrieve the user,
>and select user from dual still shows the user submitting the job.
>If you don't use this code as a job it will work as you describe.
>
Received on Mon Jun 21 1999 - 12:54:48 CDT