Re: jdbc:oracle:thin & V$SESSION

You can always use dbms_application_info.set_module to set the module and action column of v$session to provide you more details. Just call it right after you get a Connection object, and update it as frequently as you like.

Richard Ji

On 2/15/06, sol beach <sol.beach_at_gmail.com> wrote:
> 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?
>
> TIA!
>

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