How to find a link between the Session in sqlplus and OS Process ID of "java" process (not "oracle<S
1. If you start a session (e.g. via sqlplus), a new process "oracle<SID>" on OS level is created. You can find this process ID using:
select spid from v$process p, v$session s where p.addr=s.paddr and s.sid=...;
/oracle/product/db11g2/jdk/bin/IA64W/java -DORACLE_HOME=/oracle/product/db11g2 -classpath /oracle/product/db11g2
We need to know how to find a link between the session in sqlplus and OS process ID of "java" process (not "oracle<SID>" process).
select spid from v$process p, v$session s where p.addr=s.paddr and s.sid=...;
This is clear, but it is not related to subsequent java processes.
2. Later from within the same session, if you run DBMS_JAVA..., another OS process is created like this;
2. Later from within the same session, if you run DBMS_JAVA..., another OS process is created like this;
/oracle/product/db11g2/jdk/bin/IA64W/java -DORACLE_HOME=/oracle/product/db11g2 -classpath /oracle/product/db11g2
We need to know how to find a link between the session in sqlplus and OS process ID of "java" process (not "oracle<SID>" process).
0