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: Mon, 6 Jul 2009 17:02:50 +0200
Message-ID: <4814386347E41145AAE79139EAA398980931A499FE_at_ws03-exch07.iconos.be>

Hi,

The program column does not seems to be automatically set. For most sessions it is empty, for others it contains the real name of the application (such as sqlplus).

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: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: vrijdag 3 juli 2009 18:08
To: D'Hooge Freek; 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

My memory is that the thin driver populates the program column of v$session with its name, the others may also do the same.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 06 2009 - 10:02:50 CDT

This message: [ Message body ]
Next message: genegurevich_at_discover.com: "Re: create_index_cost procedure"
Previous message: Goulet, Richard: "RE: No to SQL? Anti-database movement gains steam"
In reply to: Niall Litchfield: "Re: Is there a way to know which driver (thick / thin jdbc, odbc, .net, oci, ...) was used to connect to the database"
Next in thread: Jaromir D.B. Nemec: "Re: Is there a way to know which driver (thick / thin jdbc, odbc, .net, oci, ...) was used to connect to the database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message