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