Just run the dbmsutil.sql script from $ORACLE_HOME\rdbmsxx\admin and also
prvtutil.plb as sys or have your DBA run them. This will create the
DBMS_APPLICATION_INFO package. This package has a procedure called
set_client_info which takes a parameter and puts it in the client_info
column of V$SESSION. I wrote a procedure that calls DBMS_APPLICATION_INFO
and sets the client_info. All the clients then call the procedure at
connect time.
HTH
Venkat
>
>does anyone out there know how to set the program field in the
>v$session view via the OCI?
>
>all of my OCI code shows up as
>
> ? @oahu (TNS V1-V2)
>
>making it difficult to track which applications are currently
>connected.
>
>the Oracle-provided programs seem perfectly capable of doing
>it, sqlplus and the Oracle win32 ODBC drivers correctly set
>the field, so there must be an interface to it somewhere...
>
>in the dejanews 'old' archive I was able to find a few references
>to the dbms_application_info pl/sql package for setting values
>in v$session, but I don't have this installed, so this can't be
>what Oracle folks use to set it...
Received on Tue May 19 1998 - 11:11:44 CDT
