Date: Thu, 29 Jul 1999 15:38:56 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: identify concurrent request given an Oracle sid
Message-ID: BB3B8E2BD7EED211935500A0C9C74B7B2B20F6@exch-grimm.btg.com

Hi,

Try this:

SQL l
  1  select vs.sid, fcp.oracle_process_id, fcp.session_id,
  2      fcp.concurrent_process_id, fcp.os_process_id, fcr.request_id
  3      from v$session vs, fnd_concurrent_processes fcp,
fnd_concurrent_requests fcr
  4      where fcp.concurrent_process_id=fcr.controlling_manager
  5      and vs.audsid=fcp.session_id
  6      and sid = &sid
  7*
SQL /
Enter value for sid: 20
old   6:     and sid = &sid
new   6:     and sid = 20

            Oracle
           Process
       SID    Id   SESSION_ID CONCURRENT_PROCESS_ID OS_PROC REQUEST_ID
---------- ------- ---------- --------------------- ------- ----------
        20      10      32267                  1200 4006          1590
        20      10      32267                  1200 4006          1585
        20      10      32267                  1200 4006          1586
        20      10      32267                  1200 4006          1592

SQL

N.B. : Remove line 7 and you can get the details of all present running
requests