Saturday, 28 January 2017

Finding sid for the concurrent request

SELECT ses.sid, 
            ses.serial# 
       FROM v$session ses, 
            v$process pro 
           WHERE ses.paddr = pro.addr 
                AND pro.spid IN (SELECT oracle_process_id 
                                           FROM apps.fnd_concurrent_requests 
                                        WHERE request_id = &request_id);

No comments:

Post a Comment

SQL Shared Area - BIND MISMATCH