Find Oracle session from Unix/Linux Process ID

Find Oracle session from Unix/Linux Process ID

Step1: Find Linux Process ID using following command
ps -ef 

Step2: Find the Database session information using following query

select s.username,s.sid,s.serial#,p.spid,last_call_et,status
from V$SESSION s,V$PROCESS p
where  s.PADDR = p.ADDR
and     p.spid= 6354;

Step3: Find the SQL text using following query 

select * from v$session_longops t where trunc(t.START_TIME) ='25-FEB-2014' Order by t.START_TIME desc;

Select t.SQL_FULLTEXT from v$sql t where t.SQL_ID='dj3yuw6r7p569';