High CPU Consumption and memory consumption though Concurrent request is completed
Hi ,
As i checked with top command it shows as follows and when i select request_id,PHASE_CODE,STATUS_CODE from FND_CONCURRENT_REQUESTS where ORACLE_PROCESS_ID=2198;
This query shows request is completed as follows
select request_id,PHASE_CODE,STATUS_CODE from FND_CONCURRENT_REQUESTS where ORACLE_PROCESS_ID=2198;
REQUEST_ID P S
---------- - -
2062293 C C
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2198 approd 20 0 20288 8096 5232 R 99.7 0.0 23082:27 ALECTC
2477 approd 20 0 20236 8100 5232 R 99.7 0.0 1703:05 ALECDC
22082 approd 20 0 20284 8092 5232 R 99.7 0.0 23721:54 ALECTC
24211 approd 20 0 20288 8092 5232 R 99.7 0.0 29322:48 ALECTC
42242 approd 20 0 20236 8140 5232 R 99.7 0.0 360:10.38 ALECDC
52536 approd 20 0 20236 8084 5220 R 99.7 0.0 1634:47 ALECDC
58120 approd 20 0 20236 8096 5228 R 99.7 0.0 779:54.21 ALECDC
58128 approd 20 0 20232 8104 5228 R 99.7 0.0 779:50.46 ALECDC
25020 approd 20 0 20284 8092 5232 R 79.2 0.0 28947:32 ALECTC
33652 approd 20 0 20288 8096 5232 R 76.2 0.0 26479:18 ALECTC