SQL Query to view sql for a OS Pid / process
Select a.sid,a.serial#,b.pid,c.sql_text,a.module,
to_number(b.spid) PROCESSID,
substr(a.username, 1, 12) username
From v$session a,
v$process b,v$sql c
Where a.paddr = b.addr
and a.sql_address = c.address
and b.spid = ‘&spid’
/



[...] here to extract the sql being executed by a concurrent [...]
SQL Query to list running concurrent requests « OraclePitStop - Lets share some knowledge
September 5, 2008