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