V$SESSION

[Igaduma]

Hello All,

1 database serves about 40 users, all using the same application.
When querying V$SESSION.PROGRAM it only returns the application name for 3-5 clients and the majority is empty.

Any particular reason for this ?

Thanks!
Igaduma

 

[sem]

The only reason is that this field is set by the program itself

Regards, Dima

http://seminihin.narod.ru

 

[Igaduma]

Hi Sem,

So you mean that the program itself should somehow inform Oracle ?
And how is this done ?

Many thanks,
Iga

 

[sem]

Oops, missed exact name. I was talking about module field. PROGRAM field should be populated by Oracle client software, I may assume that your clients use different versions (some of them don't populate that field correctly)

Regards, Dima

http://seminihin.narod.ru

 

[Igaduma]

Hi Sem,

By client you mean the ODBC driver used to set the ODBC connection yes ?

Thanks!

Iga

 

[sem]

No, by Oracle client I mean sql*net.

Regards, Dima

http://seminihin.narod.ru

 

[Igaduma]

Hello Sem,
Sadly my experience of sql*net is limited to seeing sqlnet.ora in the local client's orahome directory and only configuring tnsnames....:/
I have no idea what it does or how it should be set.
Thanks for any info!

Iga

 

[sem]

Since that is the only problem you experience, there's probably nothing to configure, but versions of the software in use may differ. Launch OUI (installer) and check versions of installed products. BTW, do you really need that field? AFAIK its content may vary (real program name, name of some DLL called by program etc.) and is almost beyond the control. To get the same style values everywhere you should keep configurations (including OS and even shortcut) to be the same. Though I suggest you starting from trying to use similar shortcuts.

Regards, Dima

http://seminihin.narod.ru

 

[Igaduma]

Hello sem,
Ok, got it now, will check all versions and spot the difference.

Thanks for the help!