SELECT b.sid, c.sql_text
FROM v$process a, v$session b, v$sqlarea c
WHERE a.addr = b.paddr
AND b.sql_address = c.address
AND a.spid = &pid
/
SELECT b.sid, c.sql_text
FROM v$process a, v$session b, v$sqlarea c
WHERE a.addr = b.paddr
AND b.sql_address = c.address
AND a.spid = &pid
/