Question about PROGRAM column in V$SESSION table

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