Find Oracle in the session with Linux process number (PID) Execute those SQL

1, in the use of system process PID query the corresponding physical address

SELECT v.addr,v.* from V$process V
WHERE v.spid = ' 5256;

2, through the physical address to find the corresponding sql_id

SELECT t.sql_id,t.* from V$session t
WHERE t.paddr= ' 000000025c5eb9f8 ';

3. Find the corresponding SQL statement by sql_id

SELECT Sql_text from V$sql
WHERE sql_id = ' DQU970XZS3GPV ';

The above 3 sentences are merged into one sentence:

SELECT S.sql_text
From V$sql S,
V$session T,
V$process V
WHERE s.sql_id = t.sql_id
and t.paddr = V.addr
and v.spid = ' 5256 ';

Analyze the problem specifically with this SQL statement

Find Oracle in the session with Linux process number (PID) Execute those SQL