relation between linux process and oracle process and sid

*****************************  *******************************
relation between linux process and oracle process and sid

http://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_2073.htm

select sid,paddr, sql_id,client_identifier,osuser  from v$session where
status = 'ACTIVE'

sid sessin id
paddr = process id
sql_id = current running sql

** addr = paddr
select spid from v$process where addr ='00000000DC687DB8'

** spid = pid (linux procss )

ps -ef|grep pid = 117

** sql_id = sql_id
select * from V$sql where sql_id = '7b5w34atn8q1h'

returns sql query