Re: Program name in v$ views

There are a number of reasons for this:

1. The oracle developers call a function that sets the program name. SQLPlus does that.
2. If the program name is not set, the client libraries will try to find the name as part of the logon call. For this a port specific function will be used. If that is not implemented it will return a ? or blank.
3. Now the old client libraries (7/8.0) did not always implement this function for all platforms.

So always try to use the latest client side libraries.

Anjo.

On Thursday 23 January 2003 09:39, Boivin, Patrice J wrote:
> Does anyone know why sometimes a program name appears in the v$ views for
> user sessions, and sometimes nothing?
>
> I noticed that sqlplus appears as sqlplus.exe, and other problems as their
> executable file name, but for TOAD nothing appears.
>
> Is there a way to force Oracle to collect this information?
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services | Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO | Région des Maritimes, MPO
>
> E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-- 
----------------------------------------------------------------
Anjo Kolk
http://www.oraperf.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.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).