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
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
?
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
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
?
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
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
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
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
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
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
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
11 matches
Mail list logo