确定我正在运行哪个版本的Oracle客户端的最佳方法是什么? [英] What's the best way to determine which version of Oracle client I'm running?

问题描述

该主题说明了一切:确定我正在运行的oracle客户端的确切版本的最佳方法是什么?我们的客户都在运行Windows.

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.

我发现一个建议，可以不带参数地运行tnsping实用程序，该实用程序会显示版本信息.有更好的方法吗?

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?

推荐答案

您可以针对当前会话ID(USERENV名称空间中的SID docs.oracle.com/database/121/SQLRF/functions199.htm"rel =" noreferrer> SYS_CONTEXT ).

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

例如

SELECT
  DISTINCT
  s.client_version
FROM
  v$session_connect_info s
WHERE
  s.sid = SYS_CONTEXT('USERENV', 'SID');

这篇关于确定我正在运行哪个版本的Oracle客户端的最佳方法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！