Re: JDBC leak

From: AV <avek_nospam_at_videotron.ca>
Date: Sat, 13 Apr 2002 01:34:12 -0400
Message-ID: <4qPt8.31282$jD4.1082008@weber.videotron.net>

I am not sure that it is possible. AFAIK only ip and username easily available from within oracle systables. If it is under your control,
you can force any jdbc application to supply additional info using special package
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/db ms_app.htm
[if this is what you want].

For example, we supply web user name and DBA is able to track it from database for audit purpose.

AlexV.

"Pascal Byrne" <nospam_at_nospam.com> wrote in message news:3CB72201.8070405_at_nospam.com...
> I need to find the UNIX PID associated with each session for Java JDBC
> applications, so I can catch an application which is opening Oracle
> connections without closing them. I tried the following:
>
> select s.username, s.sid, p.spid, s.process
> from v$session s, v$process p
> where s.paddr = p.addr;
>
> The process column was empty however for the Java connections.
>
> So is there another way of getting this information?
> (I am using Java 1.2, Linux and Oracle 8.1.7).
>
> Thanks,
> pascal
>
Received on Sat Apr 13 2002 - 00:34:12 CDT