Monday, June 12, 2017

How to Kill Long Running Concurrent Request

SELECT a.request_id, d.sid, d.serial#, a.requested_start_date
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
--v$sql e
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND d.paddr = c.addr
--AND d.sql_address = e.address
AND a.request_id = 13165515
AND a.phase_code = 'R'

ALTER SYSTEM KILL SESSION '732,1643';

Still concurrent Request running, update the table using below query

UPDATE fnd_concurrent_requests SET phase_code = ‘C’, status_code = ‘X’ WHERE request_ID = 13165515;

No comments:

Post a Comment