Saturday, September 6, 2014

Query for to Find All The Running Concurrent Requests

This query can be used for analyzing concurrent program run time and identifying their performances.

select request_id,
         fcpt.user_concurrent_program_name,
         completion_text,
         actual_start_date,
         actual_completion_date,
         to_date((actual_completion_date - actual_start_date), 'HH:MM:SS') duration
from   fnd_concurrent_requests fcr,
         fnd_concurrent_programs fcp,
         fnd_concurrent_programs_tl fcpt
where fcr.concurrent_program_id = fcp.concurrent_program_id
   and fcp.concurrent_program_id = fcpt.concurrent_program_id
   and fcr.actual_start_date > sysdate - 1
   order by actual_completion_date - actual_start_date desc