How To Kill runaway processes After Terminating Concurrent Request
Every concurrent Request uses some resources for running.
If we decided and terminate the conc request which is taking long time and not progress any more further.
after terminate it from front end, some times the resources may not be released soon. these processes are called runway process which will be create blocking other sessions.
so we need to manually kill the processes at DB and OS level.
Once terminate the concurrent request from the front end.
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 ;
Kill session id in Database
SQL> alter system kill session ‘session-id,session-serial’
kill pid at OS level
$ kill -9 <server pid>
Note: If you have any questions regarding above topic please comment below or contact me (email@example.com)