RE: USERENV('SESSIONID') on RAC

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Fri, 10 Oct 2003 08:54:27 -0800
Message-ID: <F001.005D2B70.20031010085427@fatcity.com>

Rich,

>Is there a way to get your own executing program from a
>9.2.0.4 RAC node?
>USERENV('SESSIONID') and SYS_CONTEXT('USERENV','SESSIONID')
>each return a
>big fat zero on RAC.

Were you logged in as SYS on the RAC node? I believe the SESSIONID (which is actually AUDSID) will be 0 for SYS/SYSDBA Internal connects...

04:45:52 SQL> show user
USER is "SYS" (JK - Connected as SYSDBA) 04:45:55 SQL> select SYS_CONTEXT('USERENV','SESSIONID') from dual;

SYS_CONTEXT('USERENV','SESSIONID')

---

---

0

04:46:04 SQL> select USERENV('SESSIONID') from dual;

USERENV('SESSIONID')

---

                   0

04:46:17 SQL> connect gl
Enter password:
Connected.
04:46:26 SQL> select USERENV('SESSIONID') from dual;

USERENV('SESSIONID')

---

             7077637

04:46:32 SQL> select SYS_CONTEXT('USERENV','SESSIONID') from dual;

SYS_CONTEXT('USERENV','SESSIONID')

---

---

7077637

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 10 2003 - 11:54:27 CDT