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_at_uptime.be>
Date: Wed, 8 Jul 2009 12:11:42 +0200
Message-ID: <4814386347E41145AAE79139EAA398980931A49B9A_at_ws03-exch07.iconos.be>

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_at_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_at_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_at_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_at_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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer

-----Original Message-----

From: Jaromir D.B. Nemec [mailto:jaromir_at_db-nemec.com] 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:_at_... program = 'JDBC Thin Client'

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

HTH Jaromir
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 08 2009 - 05:11:42 CDT