Sql Query to Check Different Client Character Set, Client Version and Client Driver or Software Connected to The Database

advertisements

_____________________________________________________________________________________________________________________

In this post provides you queries to find out the different client connection details like character set, the client software or driver etc. with their count. 

Query to find out character set.

Set pages 1000 lines 120
select CLIENT_CHARSET , count(*) 
from V$SESSION_CONNECT_INFO 
group by CLIENT_CHARSET;

CLIENT_CHARSET                             COUNT(*)
---------------------------------------- ----------
US7ASCII                                         60
AL32UTF8                                        224
Unknown                                        3686

advertisements

 

Query to find out client driver and client driver version.

Set pages 1000 lines 120
Col CLIENT_VERSION for a15
select client_driver, CLIENT_VERSION , count(*) 
from V$SESSION_CONNECT_INFO 
group by  client_driver, CLIENT_VERSION 
order by 3 desc;

CLIENT_DRIVER                  CLIENT_VERSION               COUNT(*)
------------------------------ --------------------------- ----------
jdbcthin                       11.2.0.3.0                        3552
                               11.1.0.7.0                         156
                               Unknown                             75
                               12.1.0.2.0                          44
                               19.5.2.0.0                          40
                               19.9.0.0.0                          40
jdbcthin : 12.2.0.1.0          12.2.0.1.0                          40
jdbcthin                       12.1.0.2.0                          12
SQL*PLUS                       19.5.2.0.0                           4

9 rows selected.

_____________________________________________________________________________________________________________________

Website Stats