Re: SID and sessionid

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Sun, 29 Dec 2002 16:17:57 +0100
Message-ID: <aun3to$t78$1@news.hccnet.nl>

> SQL> select userenv('sessionid') from dual;
>
> USERENV('SESSIONID')
> --------------------
> 149
>
> SQL> select * from v$session where sid=149;
>
> no rows selected
>

> SID and SESSIONID are not the same ????

No they are not. USERENV('SESSIONID') corresponds to the column AUDSID in v$session. You can find several documents on this topic on Metalink.

Peter Received on Sun Dec 29 2002 - 09:17:57 CST