High Load On Server from Process Ora_onnn
(Doc ID 1556564.1)
Last updated on MAY 21, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
You may observe that the process ora_o000 (ora_onnn) may generate high load of CPU
The output from "top" command may show:
$ top
top - 08:17:38 up 369 days, 20:59, 5 users, load average: 4.82, 5.40, 5.20
Tasks: 1036 total, 6 running, 868 sleeping, 0 stopped, 162 zombie
Cpu(s): 51.8%us, 0.5%sy, 0.0%ni, 47.3%id, 0.4%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 32959900k total, 20735032k used, 12224868k free, 919064k buffers
Swap: 102399992k total, 1372352k used, 101027640k free, 9209360k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26261 oracle 20 0 1227m 15m 15m R 99.8 0.0 5124624h oracle
14228 oracle 20 0 1233m 787m 779m S 8.2 2.4 328:32.26 oracle
..
Checking the process taking highest CPU shows:
$ ps -efx |grep 26261
26261 ? Rs 21146332:36 ora_o000_jfim HOSTNAME=tryton SHELL=/bin/bash TERM=xterm HISTSIZE=1000
What is the process: ora_o000_jfim ?
What could be the reason of high load of this process, and how to fix it ?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |