Calisan conccurrent’in request id’sinin sistem proseslerinden hangisi oldugunu bulmak, o concurrent requestini toad ve benzeri uygulamalarla takip etmek veya isletim sistemi seviyesinde islemi kill etmek icin onemlidir. Bunu asagidaki sql sorgusu ile rahatca yapabilirsiniz. Bu sql’de a.request_id’nin karsisinda yazan numaraya bakmak istediginiz request id’nin numarasini yazmaniz yeterli.

Calisan concurrent’inizin akibetini kontrol altinda tutmak artik daha kolay oldu

SELECT a.request_id, c.spid
FROM   apps.fnd_concurrent_requests a,
       apps.fnd_concurrent_processes b,
       v$process c
WHERE  c.spid IN ( SELECT c.spid
                   FROM   apps.fnd_concurrent_requests a,
                          apps.fnd_concurrent_processes b,
                          v$process c
                   WHERE  a.controlling_manager = b.concurrent_process_id
                   AND    c.pid = b.oracle_process_id
                   AND    a.request_id = 18619463
                 )
AND   a.controlling_manager = b.concurrent_process_id
AND   c.pid = b.oracle_process_id
AND   a.phase_code = UPPER('R');