SQL Query to Find Client(session) Oracle Driver Version
select SID, AUTHENTICATION_TYPE, CLIENT_VERSION, CLIENT_DRIVER from v$session_connect_info;
SID AUTHENTICATION_TYPE CLIENT_VERSION CLIENT_DRIVER
----- ------------------- -------------- ---------------
2046 DATABASE 21.9.0.0.0 jdbcthin : 21.9.0.0.0
2049 DATABASE 21.9.0.0.0 jdbcthin : 21.9.0.0.0
2055 DATABASE 21.9.0.0.0 jdbcthin : 21.9.0.0.0
4875 DATABASE 21.9.0.0.0 jdbcthin : 21.9.0.0.0
14937 DATABASE 21.9.0.0.0 jdbcthin : 21.9.0.0.0
Use below query to find application user and client machine
select ses.username,ses.machine,driv.CLIENT_DRIVER,driv.CLIENT_VERSION from gv$session ses , gv$session_connect_info driv where ses.sid=driv.sid;
No comments:
Post a Comment