How to see which RDBMS client version is used for database sessions?
We need to get the client version of all the sessions connected to a 10.2.0.4.2 DB server Linux x86-64 from DB side.
We know that V$SESSION_CONNECT_INFO is available in both 10g and 11g. In 11g there is an additional colunm
"CLIENT_VERSION". Can we get the same info on a 10g DB?
Our main issue is that we have a significant number of 9i Oracle Clients deployed across the network and few Oracle
10g Clients. Since we need to migrate everything to 10g Client, we need to know from DB Server Side, by looking at
the sessions connected to the DB, the hostname and the client version.
"CLIENT_VERSION". Can we get the same info on a 10g DB?
Our main issue is that we have a significant number of 9i Oracle Clients deployed across the network and few Oracle
10g Clients. Since we need to migrate everything to 10g Client, we need to know from DB Server Side, by looking at
the sessions connected to the DB, the hostname and the client version.
0