Find SPID from SID and Serial#:
select spid from gv$process where addr in (select paddr from gv$session where sid=&sid and serial#=&serial);
select spid from gv$process where addr in (select paddr from gv$session where sid=&sid and serial#=&serial);
No comments:
Post a Comment