High CPU on Database server for EBS 12.2
Can you please help us figure out how to resolve CPU high usage on our EBS database server (linux) ?
Here are the Top 2 sessions utilizing 100% of CPU:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
69097 oraprod 20 0 14.377g 433072 419940 R 100.0 0.7 384:57.82 oracle_69097_pr
70260 oraprod 20 0 14.367g 346840 321752 R 100.0 0.5 381:17.40 oracle_70260_pr
[root@COMPRODDB12C ~]# ps -ef | grep 69097
oraprod 69097 1 99 09:09 ? 07:00:31 oraclePROD (LOCAL=NO)
root 181441 171009 0 16:10 pts/0 00:00:00 grep --color=auto 69097
[root@COMPRODDB12C ~]# ps -ef | grep 70260
root 9534 171009 0 16:43 pts/0 00:00:00 grep --color=auto 70260
oraprod 70260 1 99 09:13 ? 07:29:43 oraclePROD (LOCAL=NO)
Thank you,
Susan