Re: USERENV('SESSIONID') on RAC
DBMS_SUPPORT.MYSID;
On 2003.10.09 23:09, Khedr, Waleed wrote:
They work fine for me on RAC 9.2.0.2
Does this help:
select unique sid from v$mystat
Waleed
-Original Message-
Sent: Thursday, September 25, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
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. And the only way I know to get
the current session's row from V$SESSION is to join it with
USERENV('SESSIONID'). If there's a better/different way to do this, I'm
listening.
Thanks!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: USERENV('SESSIONID') on RAC
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: USERENV('SESSIONID') on RAC
They work fine for me on RAC 9.2.0.2
Does this help:
select unique sid from v$mystat
Waleed
-Original Message-
Sent: Thursday, September 25, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
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. And the only way I know to get
the current session's row from V$SESSION is to join it with
USERENV('SESSIONID'). If there's a better/different way to do this, I'm
listening.
Thanks!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
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
To: Multiple recipients of list ORACLE-L
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. And the only way I know to get
the current session's row from V$SESSION is to join it with
USERENV('SESSIONID'). If there's a better/different way to do this, I'm
listening.
Thanks!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alan Gano
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: USERENV('SESSIONID') on RAC
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('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 it with
USERENV('SESSIONID'). If there's a better/different way to do this, I'm
listening.
Thanks!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: USERENV('SESSIONID') on RAC
select inst_id,username,sid,serial#
from gv$session
where sid=dbms_support.mysid;
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jesse, Rich
Sent: Thursday, September 25, 2003 12:20 PM
To: Multiple recipients 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 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 it with USERENV('SESSIONID'). If
there's a better/different way to do this, I'm listening.
Thanks!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard copies
of it and notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: USERENV('SESSIONID') on RAC
Thanks Alan and Tanel! Looks like I'll be using V$MYSTAT.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Alan Gano [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 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
To: Multiple recipients of list ORACLE-L
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. And the only way
I know to get
the current session's row from V$SESSION is to join it with
USERENV('SESSIONID'). If there's a better/different way to
do this, I'm
listening.
Thanks!
Rich
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: USERENV('SESSIONID') on RAC
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 are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*2
RE: USERENV('SESSIONID') on RAC
ORA-00904: DBMS_SUPPORT.MYSID: invalid identifier
SQL @$ORACLE_HOME/rdbms/admin/dbmssupp
Statement processed.
Statement processed.
SQL select inst_id,username,sid,serial#
2 from gv$session
3 where sid=SYS.dbms_support.mysid;
INST_ID USERNAME SIDSERIAL#
-- -- -- --
1 HOLYCOW17 8405
Interesting little tidbit, there. I'll be investigating the procedures in
that package, too...
Thanks!
Rich
Rich Jesse System/Database 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,username,sid,serial#
from gv$session
where sid=dbms_support.mysid;
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jesse, Rich
Sent: Thursday, September 25, 2003 12:20 PM
To: Multiple recipients 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 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 it with USERENV('SESSIONID'). If
there's a better/different way to do this, I'm listening.
Thanks!
Rich
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: USERENV('SESSIONID') on RAC
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-00904: DBMS_SUPPORT.MYSID: invalid identifier
SQL @$ORACLE_HOME/rdbms/admin/dbmssupp
Statement processed.
Statement processed.
SQL select inst_id,username,sid,serial#
2 from gv$session
3 where sid=SYS.dbms_support.mysid;
INST_ID USERNAME SIDSERIAL#
-- -- -- --
1 HOLYCOW17 8405
Interesting little tidbit, there. I'll be investigating the
procedures in that package, too...
Thanks!
Rich
Rich Jesse System/Database 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,username,sid,serial#
from gv$session
where sid=dbms_support.mysid;
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jesse, Rich
Sent: Thursday, September 25, 2003 12:20 PM
To: Multiple recipients 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 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 it with USERENV('SESSIONID'). If
there's a better/different way to do this, I'm listening.
Thanks!
Rich
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard copies
of it and notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
