the v_$session.process has not much in common with the unix process id. if
you want to kill the session, use the following statement:
alter system kill session v_$session.sid,v_$session.serial#
"Pascal Byrne" <nospam_at_nospam.com> schrieb im Newsbeitrag
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 Mon Apr 15 2002 - 01:20:07 CDT
