Re: PROGRAM Column in V$SESSION

Hi Paul,

We run some C/S applications and we use the program field of the V$SESSION to validate the name of the executable. All the informations of V$SESSION seem to be correct (but we use NT Workstation (Oracle Client 8.0.4 +) instead Win95). However, I remember that when we was using older version of the Oracle client with older version of MS OS (like Win3.11 and Win95), we got that kind of error. I suggest to look carfully to the version that you use (on your client) to see if there is some kind of pattern.

About WINSOCK.DLL, does youre Oracle connection use TCP/IP? If I'am right, it can make sence that you found WINSOCK.DLL as program name instead PSTLS.EXE (but this is a bug too...).

Good luck,

Benoit
benoit.bouthillier_at_loto-quebec.com

Paul de Anguera <nospam_at_quidnunc.net> a écrit dans le message : 7oghia$8tn$5_at_news.chatlink.com...
> In article <37A8F8EC.42D7EFB4_at_bostonbio.com>,
> Jeffrey Janousek <jjanousek_at_bostonbio.com> wrote:
> >My database shows the executable program (PLUS33.EXE, DDE132.EXE, etc.)
> >in the V$SESSION for some users, but others have a default of 'OraPgm'.
> >Where does this value come from and how can I change the client
> >configuration (or other) to show the correct OS product connected? The
> >server machine is Solaris and the clients are Windows95.
> I've seen similar behavior for column OSUSER. If
> the client sets variable USERNAME it shows up in
> OSUSER. If the client doesn't, OSUSER is set to
> "OraUser" as a default (what a wasted opportunity
> to make good use of a null value). So my guess is
> that your clients sometimes fail to set the
> program name. I have also noticed bogus program
> names like C:\WINDOWS\WINSOCK.DLL . Since we run
> a client-server system with a single executable,
> PSTLS.EXE, that has nothing to do with browsers, I
> think that can't be right.
>
> Paul de Anguera | "You can't write a chord ugly enough to say
> Reply to: | what you want to say sometimes, so you have to
> deanguer@ | rely on a giraffe filled with whipped cream."
> quidnunc.net | - Frank Zappa
Received on Sat Aug 07 1999 - 08:09:15 CDT