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

windows oracle

chris · Jul 23, 2009 · Viewed 374.8k times · Source

The subject says it all: What is the best way to determine the exact version of the oracle client I'm running? Our clients are all running Windows.

I found one suggestion to run the tnsping utility, without parameters, which does display the version information. Is there a better way?

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

Answer

You can use the v$session_connect_info view against the 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');