Re: Session# and SID In a Trigger

"B. Alfredo M. Naling, Jr." wrote:

> 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

SELECT DISTINCT sid
FROM v$mystat

Then go to v$session

Also look at the SYS_CONTEXT function if you have 8i or above.

Speaking of which please consider the value of providing useful information to those trying to help you in the future such as version and edition of Oracle, hardware and operating system when relevant.

Daniel Morgan Received on Thu Oct 03 2002 - 10:07:03 CDT