How To Kill runaway processes After Terminating Concurrent Request
Every concurrent Request uses some resources for running. If we find that the concurrent request is taking long time and decided to terminate the concurrent request , the resources may not be released soon. These processes are called runaway processes. So we need to manually kill the processes at database and os level to have the resources released to the system. Terminate the concurrent request from the front end. Then SQL>select request_id,oracle_process_id,os_process_id from fnd