Monday, June 12, 2017

Find Request ID from SID

SELECT   vp.spid,
         vs.sid,
         fcr.request_id
  FROM   v$process vp,
         v$session vs,
         fnd_Concurrent_requests fcr
 WHERE   vs.paddr              = vp.addr
   AND   fcr.oracle_process_id = vp.spid
   AND   vs.sid                = :l_sid

No comments:

Post a Comment