RE: Is there a way to know which driver (thick / thin jdbc, odbc, .net, oci, ...) was used to connect to the database

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "Jaromir D.B. Nemec" <jaromir@xxxxxxxxxxxx>, Niall Litchfield <niall.litchfield@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 8 Jul 2009 12:11:42 +0200

Hi Jaromir,

I have tested this on a database for which I now that the application is using 
thin jdbc (10.2.0.4 on solaris):

sys@WPS50> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

5 rows selected.

sys@WPS50> select distinct program from v$session where service_name = 
'WEBSPHERE1_DTP';

PROGRAM
------------------------------------------------


1 row selected.

Here, the program column is not filled in.
But on a Linux system:

sys@DPNAVIS> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

5 rows selected.

sys@DPNAVIS> select program, count(*) from gv$session where service_name = 
'NAVIS_SRV' group by program order by program;

PROGRAM                                            COUNT(*)
------------------------------------------------ ----------
JDBC Thin Client                                         78
SQL Developer                                             1
tscom3.exe                                                1

3 rows selected.


So, it seems to be platform dependend.


Regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer




-----Original Message-----
From: Jaromir D.B. Nemec [mailto:jaromir@xxxxxxxxxxxx]
Sent: dinsdag 7 juli 2009 1:13
To: D'Hooge Freek; Niall Litchfield; oracle-l-freelists
Subject: Re: Is there a way to know which driver (thick / thin jdbc, odbc, 
.net, oci, ...) was used to connect to the database

Hi Freek,

my tests on 10.2.0.3 Linux show that at least the JDBC driver set the
program column in v$session

thin driver - connection string jdbc:oracle:thin:@...   program = 'JDBC Thin
Client'

OCI (thick) - connection string jdbc:oracle:oci:@..  program = 'java.exe'

HTH

Jaromir
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2009