DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 19, 2016

How To Kill runaway processes After TerminatingConcurrent Request:

How To Kill runaway processes After TerminatingConcurrent Request:


Terminate the concurrent request from the front end. Then

SQL>select request_id,oracle_process_id,os_process_id from
fnd_concurrent_requests where request_id=’&Req_Id’;

SQL>select p.spid , s.sid , s.serial# from v$session s , v$process p where s.paddr
= p.addr and s.process = &os_process_id ;

SQL> alter system kill session ‘session-id,session-serial’

$ kill -9 <server pid>

No comments: