I am a software engineer and working as an Oracle Apps DBA. I have started this blog to share my knowledge with others . Here you can find stuff related to Oracle DBA,Oracle Applications DBA,
Wednesday, July 19, 2017
Find Process ID from SID
select spid
FROM V$SESSION S, V$PROCESS P
where s.sid = '362899073'
and s.paddr = p.addr;
No comments:
Post a Comment