Search This Blog

Showing posts with label Find SID from Concurrent Program request ID. Show all posts
Showing posts with label Find SID from Concurrent Program request ID. Show all posts

Sunday, November 14, 2010

Find SID from Concurrent Program request ID

SELECT sid                      
        FROM v$session
       WHERE paddr LIKE
    (SELECT addr   
         FROM v$process
        WHERE spid    =
            (SELECT oracle_process_id    
               FROM fnd_concurrent_requests
              WHERE request_id  = TO_NUMBER(<your request id>)
            )
   );