Saturday, September 18, 2010

How to find spid from sid?

select spid, s.sid, s.serial#, osuser, s.program from v$process p, v$session s where p.addr=s.paddr and s.sid = &sid order by spid;

No comments:

Post a Comment