>>First get the Concurrent Request you are facing issue with.
>>Then get the SID information for a running request by using below query connecting as apps user.
SQL> column process heading "FNDLIBR PID"
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b, v$process c,v$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';
>>AFter that get the SQL_ID and SQL_TEXT which will be helpfull for analysing for any conflicts by using v$locked_object and many so more options.
col action format a20
col module form a30
select sid,sql_id,action,module from v$session where action like '%Conc%';
select sql_text from v$sqlarea where sql_id='SQL_ID';
>>Then get the SID information for a running request by using below query connecting as apps user.
SQL> column process heading "FNDLIBR PID"
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b, v$process c,v$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';
>>AFter that get the SQL_ID and SQL_TEXT which will be helpfull for analysing for any conflicts by using v$locked_object and many so more options.
col action format a20
col module form a30
select sid,sql_id,action,module from v$session where action like '%Conc%';
select sql_text from v$sqlarea where sql_id='SQL_ID';
Click here to see the SQL Queries To Analyze All Concurrent Requests in a systematic approach.
More Posts are coming next...
Happy Learning & Sharing.........
Comments
Post a Comment