our server is running oracle database, it has:
load average: 1.77, 1.76, 1.73
using only one cpu. is that too high?
thanks.
Not necessarily. A very rough rule of thumb is keep those numbers under 2.0 most of the time. What you need to worry about more is a few individual processes eating lots of cpu.
prstat is your friend for this. What those numbers mean is this:
Assume you are going to the bank to do a transaction. When you get there, how many people are in front of you in the the line? So if you have to keep coming back to the line then how long, on average do you have to wait to get service. As those numbers grow it means you wait longer and longer for service. On systems running databases the db frequently uses a lot of resources, comapred with user processes, but it is designed to optimize the use of those resources. So it is common to see some cpu usage like the ones you have.
What exact performance problem do you have?
1 Like
Thanks Jim.
I had upgraded total RAM from 1Gb to 5Gb and, iirc, load did not decrease (perhaps it even increased). However, there is plenty of free RAM now and it doesn't swap like it used to; ssh seems more responsive. I haven't noticed performance problem really, but we plan to expand oracle database and need to know if hardware can handle it.
Its not high. 1 % cpu only used. Rest idle..
1 Like
@SunSolars_admin, you are confusing the system load average, which relates to the process run queue length in the last 1, 5 and 15 minutes with the percentage the CPU is running system (kernel) code.
1 Like