Showing posts with label How to identify the sid using Server Process id in oracle database. Show all posts
Showing posts with label How to identify the sid using Server Process id in oracle database. Show all posts

Friday, January 13, 2012

How to identify the sid using Server Process id in oracle database

select  sid
from   v$session
where paddr in (select addr from v$process
                          where background is null
                          and    spid=&Server_process_id);