Group Team

This is the mostly faced issue while running Plsql based concurrent program.
We may not be sure which is the query being executed.
We can take a TKPROF and check the performance of the query.
But to get the TKPROF the program must be completed first.

We can use the below query to get the sql query that is being executed for the currently running Concurrent program.
Request id is the input for this query.


SELECT  fcr.request_id,
              fcp.user_concurrent_program_name,
              vsq.sql_text
  FROM  fnd_concurrent_requests fcr,
               v$process vp,
               v$session vs,
               v$sql vsq,
               fnd_concurrent_programs_vl fcp
 WHERE fcr.request_id =Request Id’
   AND    fcr.oracle_process_id = vp.spid
   AND    vs.sql_address = vsq.address
   AND    vs.paddr = vp.addr
   AND    fcr.concurrent_program_id = fcp.concurrent_program_id;
Labels: edit post
0 Responses

Post a Comment