下面的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;
朋友提供，较为准确：
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
*********************************查看运行存储过程************************************************

select * from v$access o where o.OBJECT like upper('cux_sqjt_bom_update')

select a.serial# from v$session a WHERE A.SID=515  ---------通过sid 获取serial#
alter system kill session '515,57159' ----------eg: alter system kill session '123,3211'
*********************************查看历史运行请求************************************************
SELECT req.request_id,
       fcp.user_concurrent_program_name,
       usr.user_name,
       req.request_date,
       trunc(SYSDATE) - trunc(request_date) days,
       req.completion_text,
       req.argument_text,
       req.logfile_name,
       req.outfile_name,
       req.actual_start_date,
       req.actual_completion_date
  FROM applsys.fnd_concurrent_requests req,
       apps.fnd_concurrent_programs_vl fcp,
       applsys.fnd_user                usr
 WHERE req.concurrent_program_id = fcp.concurrent_program_id
   AND req.requested_by = usr.user_id
   --AND req.request_id = 19612168
    AND fcp.user_concurrent_program_name LIKE 'CUX:寄存冲减检查报表(按日期)%'
    and req.argument_text like '1001, 141%'
 ORDER BY fcp.user_concurrent_program_name