Showing posts with label oracle sid from spid. Show all posts
Showing posts with label oracle sid from spid. Show all posts

Saturday, September 18, 2010

How to find sid from spid?

select s.username, s.sid, s.serial#,p.spid, to_char(s.logon_time, 'dd-mon-yy-hh24:mi') day, s.program from v$process p, v$session s where p.addr = s.paddr and p.spid = &spid;