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:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...