RE: Find Oracle Client Version - from the Database side

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 3 Mar 2010 11:55:02 -0500
Message-ID: <SNT130-ds1189DE2196FEEE10F69A8EA63A0_at_phx.gbl>

On my 10.2.04 db it only shows the info from the db server. Ie. No matter where you connect from it just shows stuff like TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bill Ferguson
Sent: Wednesday, March 03, 2010 11:47 AM To: tyfaniew_at_uoregon.edu
Cc: oracle-l digest users
Subject: Re: Find Oracle Client Version - from the Database side

Try looking in SYS.V$_SESSION_CONNECT_INFO.

There are columns there (at least in my 11.1.0.7) called CLIENT_VERSION and CLIENT_DRIVER. These may be what you need.

--

• Bill Ferguson

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 03 2010 - 10:55:02 CST