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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

0 comments:

Post a Comment

 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer