Query to find concurrent program run time

Query to find concurrent program run time

In this post , We will be discuss about Query to find concurrent program run time. This sql query will help to extract the each concurrent program request total run time. We can compare the execution time of each concurrent program request using this sql query. This is one of the important sql query to track the concurrent request performance. Here below is the detail about Query to find concurrent program run time.

2 Important Tables used by Query to find concurrent program run time

1.fnd_concurrent_programs_tl  tl,

2.fnd_concurrent_requests    

Detail SQL Query to find concurrent program run time

SELECT 

       rq.request_id                          "Concurrent Request ID",

       tl.user_concurrent_program_name        "Concurrent Program Name",

       rq.actual_start_date                   "Start Date",

       rq.actual_completion_date              "Completion Date",

       ROUND((rq.actual_completion_date -

           rq.actual_start_date) * 1440, 2)   "Program Runtime (Minutes)"      

  FROM applsys.fnd_concurrent_programs_tl  tl,

       applsys.fnd_concurrent_requests     rq

 WHERE tl.application_id        = rq.program_application_id

   AND tl.concurrent_program_id = rq.concurrent_program_id

   AND rq.actual_start_date IS NOT NULL

   AND rq.actual_completion_date IS NOT NULL

 ORDER BY rq.request_id DESC

Query to find concurrent program run time