Re: Session# and SID In a Trigger

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 3 Oct 2002 21:40:23 +1000
Message-ID: <lRVm9.45363$g9.129678@newsfeeds.bigpond.com>

Hi There,

Not pretty but it works.

SELECT sid, serial#
FROM v$session
WHERE sid = (SELECT sid

                        FROM v$mystat
                        WHERE rownum = 1);

Cheers

Richard
"B. Alfredo M. Naling, Jr." <someone_at_hotmail.com> wrote in message news:angthm$m7r$1_at_reader01.singnet.com.sg...
> How do I determine the session serial# and session sid inside a trigger. I
> know
> you can query v$session with a "where username = user" but I don't want
this
> criteria as it is possible that one user is logged on more than once.
>
> Help!!!
>
> cheers,
> Alfredo
>
>
Received on Thu Oct 03 2002 - 06:40:23 CDT