How to find the concurrent request id from the sql_id?
Hi all:
We have some performance issue. We have identified three troubled sql id. I want to find out which concurrent request do these sql id belongs to. I found an oracle notes and point to below query; however, since the concurrent request is not currently running and there is no active session, thus the below query returns no rows. Is there another way to find the concurrent request from sql_id of an already completed concurrent request?
SELECT fcr.request_id,
fcp.user_concurrent_program_name,
vsq.sql_text,
vsq.SQL_ID
FROM fnd_concurrent_requests fcr,
v$process vp,