Find Database Query From the Linux PID
PID=32370
select t.sql_id,t.sql_text from gv$process p , gv$session s , gv$sqlarea t
where p.addr=s.paddr
and s.sql_address=t.address
and s.sql_hash_value=t.hash_value
and p.spid = 32370;
Recent Posts
PID=32370
select t.sql_id,t.sql_text from gv$process p , gv$session s , gv$sqlarea t
where p.addr=s.paddr
and s.sql_address=t.address
and s.sql_hash_value=t.hash_value
and p.spid = 32370;