What's the best way to determine which version of Oracle client I'm running?

Question

The subject says it all: Is there a better way to determine this exact version of the oracle client I'm running? Our clients are all running on Windows.

I found one suggestion to run a tnsping utility, without using the parameters, which display the version and information. Is there any better way to achieve it?

Does a client install put the information in any sort of text file?

Answer 1

You can use a v$session_connect_info view against a current session ID (SID from the USERENV namespace in SYS_CONTEXT).

e.g.

SELECT

  DISTINCT

  s.client_version

FROM

  v$session_connect_info s

WHERE

  s.sid = SYS_CONTEXT('USERENV', 'SID');

Want to be a Linux expert? Come and join this Linux course

Do check out the video below