Wednesday, January 15, 2014

Oracle query to find PID TO SID

 Oracle query to find PID TO SID

select sid,serial#,inst_id from gv$session;
select PID, p.PROGRAM
from gv$process p, gv$session s
where s.paddr=p.addr
and sid=;

No comments:

Post a Comment