Wednesday, September 17, 2008

How to find os process id,sid of a concurrent request

select sid,serial#,process,module,action from v$session where process=(SELECT p.os_process_id FROM FND_CONCURRENT_REQUESTS r, FND_CONCURRENT_PROCESSES p where r.controlling_manager = p.concurrent_process_id and request_id=2759835)

Here process is the os process id for the concurrent request.

1 comment:

Santosh said...

Great, I wanted to check SID from PID and finally get it.