oradbakar
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;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment