RE: jdbc:oracle:thin & V$SESSION

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 15 Feb 2006 22:29:15 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF205C93@MSXVS04.trivadis.com>

>When jdbc:oracle:thin is used to connect to an
>Oracle database, V$SESSION.USERNAME is blank &
>V$SESSION.MACHINE contains "jdbcclient". Both
>of these are less than useful.
>Is there anything that can be done in the Java
>code to result in better information contained in
>V$SESSION?
Current JDBC drivers provide this information. Just be aware of bug# 3735857 that hides OSUSER in 10g.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 15 2006 - 15:29:15 CST