Showing posts with label concurrent. Show all posts
Showing posts with label concurrent. Show all posts

Monday, March 10, 2014

how to find running concurrent process id in operation system for R12,R11

execute below sql definition in sqlplus with apps user.

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$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 = &Request_ID
AND a.phase_code = 'R';

it will want concurrent no,

after find out process id, you can list.

ps -ef | grep process_id