find os process id,sid of a concurrent request

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)

No comments:

Oracle Database 23AI session-related scripts.

  Oracle Database 23AI session-related scripts. ##Columns Name Details### sid - session identifier serial# - session serial number osuser - ...