Re: Concurrent requests hang

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Concurrent-requests-hang-tp912p922.html

You can get the sid of a concurrent request using sql queries, such as ;

/*Finding SID of a Concurrent Request */

select b.sid, oracle_session_id, oracle_process_id, os_process_id
from fnd_concurrent_requests a ,
v$session b
 where a.request_id=&request_id and
        a.ORACLE_SESSION_ID = b.AUDSID
--------------------------------------------------------------------------