OraFAQ Forum: Client Tools » Which client version is used?

Home » Other » Client Tools » Which client version is used? (Oracle 11G, Win7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Which client version is used? [message #672162]

Thu, 04 October 2018 12:46

OlafCologne
Messages: 11
Registered: September 2008
Location: Cologne

Junior Member

Dear Forum Participants,

there is a possibility to read after the session has been set up,
which client version is used?

Several Oracle client versions are installed on the desktop PCs.
How can I find out which version the application is actually using?

Thank you very much.

Report message to a moderator

Re: Which client version is used? [message #672163 is a reply to message #672162]

Thu, 04 October 2018 12:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

OlafCologne wrote on Thu, 04 October 2018 10:46

Dear Forum Participants,

there is a possibility to read after the session has been set up,
which client version is used?

Several Oracle client versions are installed on the desktop PCs.
How can I find out which version the application is actually using?

Thank you very much.

Is application 3-tier?

It depends.
DB Server only know what client details are provided.
you can query V$SESSION.PROGRAM
You can query V$SESSION.CLIENT_INFO

You can't push a string & force details from the client; what ever they may be.

What will you do differently after you know the client details?

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: Which client version is used? [message #672164 is a reply to message #672162]

Thu, 04 October 2018 14:55

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> desc V$SESSION_CONNECT_INFO
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SID                                       NUMBER
 SERIAL#                                   NUMBER
 AUTHENTICATION_TYPE                       VARCHAR2(26)
 OSUSER                                    VARCHAR2(30)
 NETWORK_SERVICE_BANNER                    VARCHAR2(4000)
 CLIENT_CHARSET                            VARCHAR2(40)
 CLIENT_CONNECTION                         VARCHAR2(13)
 CLIENT_OCI_LIBRARY                        VARCHAR2(27)
 CLIENT_VERSION                            VARCHAR2(40)
 CLIENT_DRIVER                             VARCHAR2(9)
 CLIENT_LOBATTR                            VARCHAR2(23)
 CLIENT_REGID                              NUMBER

Report message to a moderator