How to know the sql query that is being executed for the long running concurrent program in Oracle apps?
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;
Post a Comment