–下面的SQL 可以根据Request ID 找到对应的Session 信息:
select *
from v$session
where paddr in
(select addr
from v$process
where spid =
(select b.oracle_process_id
from apps.fnd_concurrent_requests b
where b.request_id = &req_number))
–或者进一步找到正在运行的SQL:
select sql_text
from v$sqltext_with_newlines
where hash_value in
(select SQL_HASH_VALUE
from v$session
where paddr in
(select addr
from v$process
where spid =
(select b.oracle_process_id
from apps.fnd_concurrent_requests b
where b.request_id = &req_number)))
order by piece;
–通过request id 和sql id 找到相关脚本：
SELECT ses.sid,
ses.serial# ,
Ses.sql_id
FROM v$session ses,
v$process pro
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id =
select sql_text from v$sqltext where sql_id=’0kkhhb2w93cx0′ order by piece
Original: https://www.cnblogs.com/quanweiru/p/9128161.html
Author: 全威儒
Title: 根据请求号(request ID)查找正在运行的sql
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/32691/
转载文章受原作者版权保护。转载请注明原作者出处！
