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: [EMAIL PROTECTED] -- ---------------------------------------------------------------- Anjo Kolk http://www.oraperf.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk 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).
