QUERY TO CHECK THE PID FROM THE 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=<SID above>;
select PID, p.PROGRAM
from gv$process p, gv$session s
where s.paddr=p.addr
and sid=<SID above>;
No comments:
Post a Comment