Dear All,
i have an issue finding the some of the the concurrent requests SID specifically the ones run PL/SQL programs
i can find the SID for the main requests that runs the PL/SQL block using the statement , and most of the time it is running using standard manager
SELECT a.request_id,
d.sid,d.serial#,d.osuser,d.process,c.SPID,c.INST_ID,d.sid,d.serial#,d.status,
d.PROCESS,d.username,d.module
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
gv$process c,
gv$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id = d.audsid
AND a.request_id = &request_id
AND a.phase_code = 'R';
but when i check the SID to check the performance i find it is running the PL/SQL block like
/* Formatted on 7/17/2025 1:31:43 PM (QP5 v5.391) */
BEGIN
XXAC_PO_RCV_PKG.upload_file ( :errbuf, :rc, :A0);
END;
Please, how can I get the real SID running, and if this request is calling another transactional manager,
i hope my Question is clear
BR
Hossam