3. How to Identify the Server Process Id using the oracle session id (sid) in oracle database

select spid

from  v$process

where background is null

and     addr in (select paddr

                        from   v$session

                        where  sid=&session_id);