SELECT to_char(s.sid) || ',' || to_char(s.serial#), sql_text
FROM applsys.fnd_concurrent_requests r,
v$process p,
v$session s,
v$sqltext_with_newlines sqlt
WHERE r.oracle_process_id = p.spid
AND p.addr = s.paddr(+)
AND s.sql_address = sqlt.address(+)
AND s.sql_hash_value = sqlt.hash_value(+)
AND r.request_id = 3678865
ORDER BY piece;
以上SQL,用了几年了,把3678865改为你的请求号即可。当然了,请求结束了就查不出来了。
阅读(1559) | 评论(0) | 转发(0) |