Re: How to identify a session ? How to get SID ?

From: wangz <php_at_yeah.net>
Date: 4 Jun 2002 18:41:19 -0700
Message-ID: <6f77ff2a.0206041741.34efa9f9@posting.google.com>

"R Chin" <rchin_at_panix.com> wrote in message news:<adj0mq$a3v$2_at_reader1.panix.com>...
> We telnet to the UNIX box and use single sign-on (BEQ protocol) to log on,
> so how do I identify my (or a )session? SID ? how do I get that ?
> OSUser won't do either because we send job the CRON.
>
> Thanks

select sid from v$session where audsid=userenv('sessionid');

oracle session manager at http://www.wangz.net may gives you more detail information about sessions.

Gudu Software
http://www.wangz.net Received on Tue Jun 04 2002 - 20:41:19 CDT