Re: USERENV('SESSIONID') on RAC

2003-10-10 Thread Mladen Gogala
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

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

2003-10-09 Thread Khedr, Waleed
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

2003-09-25 Thread Alan Gano

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

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('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

2003-09-25 Thread Mladen Gogala
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

2003-09-25 Thread Jesse, Rich
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

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

2003-09-25 Thread Jesse, Rich
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

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-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).