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                              SID    SERIAL#
---------- ------------------------------ ---------- ----------
         1 HOLYCOW                                17       8405

Interesting little tidbit, there. I'll be investigating the procedures in that package, too...

Thanks!

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> 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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] 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: Rich.Jesse_at_qtiworld.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).