Re: Q: How to obtain SID for my session?
From: Kevin McDaniel <kmcdaniel96_at_home.com>
Date: 12 Aug 2001 18:24:13 -0700
Message-ID: <9c966595.0108121724.332a303a_at_posting.google.com>
Date: 12 Aug 2001 18:24:13 -0700
Message-ID: <9c966595.0108121724.332a303a_at_posting.google.com>
"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
Why can't you just USE v$session? Try..
SELECT SID, SERIAL#, USERNAME FROM V$SESSION WHERE USERNAME = '<USERNAME>'; Received on Mon Aug 13 2001 - 03:24:13 CEST