Re: leaking JDBC apps from v$session s, v$process p where s

On Fri, 12 Apr 2002 17:47:52 GMT, Pascal Byrne <nospam_at_nospam.com> wrote:

>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

Was the *process* column empty or the *spid* column? And of top of that : you aren't
- running MTS
- connecting as a privileged account like SYS

You could consider studying the sys_context function in 8i, which will be capable to retrieve a number of things, including the IP address of the session

-- 
Regards


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address