Re: USERENV('SESSIONID') on RAC

2003-10-10 Thread Mladen Gogala
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. My ultimate goal is to get the executing session's program, and the only place I can find that info is in V$SESSION. And the only way I know to get

RE: USERENV('SESSIONID') on RAC

2003-10-10 Thread John Kanagaraj
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

RE: USERENV('SESSIONID') on RAC

2003-10-09 Thread Khedr, Waleed
? USERENV('SESSIONID') and SYS_CONTEXT('USERENV','SESSIONID') each return a big fat zero on RAC. My ultimate goal is to get the executing session's program, and the only place I can find that info is in V$SESSION. And the only way I know to get the current session's row from V$SESSION is to join

USERENV('SESSIONID') on RAC

2003-09-25 Thread Jesse, Rich
Hey all, 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. My ultimate goal is to get the executing session's program, and the only place I can find that info is in V$SESSION

RE: USERENV('SESSIONID') on RAC

2003-09-25 Thread Alan Gano
? USERENV('SESSIONID') and SYS_CONTEXT('USERENV','SESSIONID') each return a big fat zero on RAC. My ultimate goal is to get the executing session's program, and the only place I can find that info is in V$SESSION. And the only way I know to get the current session's row from V$SESSION is to join

Re: USERENV('SESSIONID') on RAC

2003-09-25 Thread Tanel Poder
Join it with (select sid from v$mystat where rownum 2) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 7:19 PM Hey all, Is there a way to get your own executing program from a 9.2.0.4 RAC node? USERENV

RE: USERENV('SESSIONID') on RAC

2003-09-25 Thread Mladen Gogala
of list ORACLE-L Subject: USERENV('SESSIONID') on RAC Hey all, 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. My ultimate goal is to get the executing session's

RE: USERENV('SESSIONID') on RAC

2003-09-25 Thread Jesse, Rich
25, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: USERENV('SESSIONID') on RAC I often do this: select * from v$session where sid = (select distinct sid from v$mystat); Alan. -Original Message- Sent: Thursday, September 25, 2003 9:20 AM

RE: USERENV('SESSIONID') on RAC

2003-09-25 Thread Jamadagni, Rajendra
Title: RE: USERENV('SESSIONID') on RAC userenv('sessionid') matches with audsid in v$session ... but you already knew that ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

RE: USERENV('SESSIONID') on RAC

2003-09-25 Thread Jesse, Rich
Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: USERENV('SESSIONID') on RAC select inst_id

RE: USERENV('SESSIONID') on RAC

2003-09-25 Thread Mladen Gogala
I like your username. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesse, Rich Sent: Thursday, September 25, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: USERENV('SESSIONID') on RAC ORA