My Oracle Support Banner

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 later
Oracle 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.