Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SID and sessionid

SID and sessionid

From: zeb <thierry.constant2_at_wanadoo.fr>
Date: Sun, 29 Dec 2002 15:43:02 +0100
Message-ID: <3e0f09f8$0$17188$626a54ce@news.free.fr>


Hi,

I do:

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 ????

Thanks for any hints ...

Oracle 8.1.7
Linux

Oracle 8.1.7
Linux Received on Sun Dec 29 2002 - 08:43:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US