Re: how to get serial# of current session or OS user_name

Hi,

v$mystat will show you your sid.

So the query:

select serial#, osuser from v$session
  where sid =
    (select distinct sid from v$mystat);

Will do the trick.
Your session will need select on v$session to do this.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Blaze" <b_kwiatkowski_at_poczta.onet.pl> wrote in message news:a9v4m4$jj0$1_at_news.tpi.pl...
> Hi!
> I'm trying to get a serial# or OS user name of current session.
> Thanks in advance for help
> Blaze
>
>
Received on Sun Apr 21 2002 - 15:28:07 CDT