Search This Blog

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>)
            )
   );

No comments:

Post a Comment