Re: How to obtain SID for my session?

From: Guang Mei <gmei_at_proteome.com>
Date: Fri, 10 Aug 2001 17:45:03 -0400
Message-ID: <oyYc7.893$Fn4.131774_at_news.shore.net>


 select name from v$database;

HTH. Guang

"Stan Benda" <sbenda_at_uswest.com> wrote in message news:AVXc7.925$3R1.249122_at_news.uswest.net...
> Closest I found is
>
> select userenv(sessionid) from dual;
>
> but it is audit ID. I would like to find SID or serial# for v$session
>
> Any idea?
>
> Stan
>
>
Received on Fri Aug 10 2001 - 23:45:03 CEST

Original text of this message