Use Below Query to find out OS PID using SID in oracle.
select s.sid,s.serial#,p.spid os_pid,s.status, s.osuser ,s.username, s.COMMAND,s.MACHINE,s.MODULE, s.SCHEMANAME,s.LOCKWAIT,s.action from v$session s, v$process p WHERE s.paddr = p.addr and s.sid =&SID
No comments:
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.