Some times we need to kill a hang concurrent request, and to kill it, we need to find the sid and serial# of that concurrent request.
Following SQL query can be run with APPS user on APPS Database , it will need to provide the concurrent request id, and then it will give the sid and serial# of that concurrent requests, more information can also be obtained from v$session and v$sqlarea views.
Following is the SQL query
FROM v$session ses,
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
WHERE request_id = &request_id);