Re: Question about PROGRAM column in V$SESSION table

Your Pro*C code can get the image name from argv[0]

if you need the compleate file spec, shoot me a mail message.

Stefano UNTERNAEHRER (unter_at_mecati.mecasoft.ch) wrote:
:> Hi folk!
:> Our users all use 3 motif applications with pro*c library to interface
:> to the database, except me, also using sqlplus and sqldba.
:> The v$session table is interesting, except the PROGRAM column's value
:> where [at the moment] it doesn't knows the program name. In this case
:> I would like to see the motif application name instead of the question mark.
 

:> column ORACLE_USER format A11
:> column HPUX_USER format A9
:> column WORKSTATION format A11
:> column PID format 99999
:> column PROGRAM format A30
:> select
:> lower(username) ORACLE_USER,
:> osuser HPUX_USER,
:> machine WORKSTATION,
:> process PID,
:> program
:> from
:> v$session
:> where
:> username is not null and username != 'SYSTEM'
:> order by sid;

:> As for example:
 

:> ORACLE_USER HPUX_USER WORKSTATION PID PROGRAM
:> ----------- --------- ----------- --------- ------------------------------
:> marco marco loc1 16424 ? _at_loc1 (TNS interface)
:> martha martha loc1 17090 ? _at_loc1 (TNS interface)
:> martha martha loc1 17076 ? _at_loc1 (TNS interface)
:> mecaora unter nodesu 21685 sqlplus_at_nodesu (TNS interface)

:> The CONNECT command in the Pro*C library is like:
:> EXEC SQL CONNECT / USING prod7;
 

:> Any idea how to tell to oracle the program's name ???
:> Thank you for any help,
:> Stefano
 

:> ------- OUR INSTALLATION AT A GLANCE (HP 9000/715 running HP-UX 09.07) -------
 

:> ORACLE7 Server (RDBMS) 7.1.6.2.0 CORE Version 2.3.7.1.0
:> Oracle Server Manager 2.1.3.0.0 Oracle Network Manager 2.1.6.0.0
:> SQL*Net V2 2.1.6.1.0 TCP/IP Protocol Adapter (V2) 2.1.6.1.0
:> PL/SQL V2 2.1.6.2.0 SQLLIB 1.6.7.0.0
:> SQL*Plus 3.1.3.7.1 Pro*C 2.0.6.0.0
:> ------------------------------------------------------------------------------
:> Stefano Unternaehrer Mecasoft SA
:> Oracle DBA 6600 Muralto
:> PL/SQL, Pro*C, C, XWindow & Motif Switzerland Europe
:> Software Developer fax: +41 91 743 5507
:> email: dba,unter_at_mecasoft.ch voice: +41 91 743 7444

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.