Query to find the SID of running concurrent request

 

Use  below query to find the SID of running concurrent request. It may require to tune the concurrent requests. 

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID ,d.inst_id

FROM apps.fnd_concurrent_requests a,

apps.fnd_concurrent_processes b,

gv$process c,

gv$session d

WHERE a.controlling_manager = b.concurrent_process_id

AND c.pid = b.oracle_process_id

AND b.session_id=d.audsid

AND a.request_id =&req_id
AND a.phase_code = 'R';

Pass the concurrent request ID when it prompts.

Thanks for going through the post...............................