High system load ...

[K.C. Chan]

getting high load on System, I am thinking the box is overloaded with work, only application running on it, is oracle. Here's the output from sar:

23:03:31 %usr %sys %wio %idle
23:03:36 52 43 2 3
23:03:41 54 43 2 1
23:03:46 56 40 2 1
23:03:51 50 44 5 2
23:03:56 56 44 0 0
23:04:01 52 41 4 3
23:04:06 54 41 5 1
23:04:11 54 45 1 0
23:04:16 56 40 3 1
23:04:21 56 44 0 0

Average 54 42 2 1

I need a second opinion.

[Steven E. Protter]

Take a look at the top display and see who owns the processes that are on the list. Oracle is surely able to do this, but you need data.

I'm attaching a script set that will identify the culprit.

SEP

[Michael Tully]

The could be a number of factors involved. The size of the server (RAM No. of CPU's), the size of the database being used, and how well it is tuned can also be important factors in determining whether you have a performance problem.

[Tim D Fulford]

This is not the worst ratio I've seen... How much IO is being done? Are you sequentially scanning tables? of the queries that are running, are they properly indexed?

Tim

[Nicolas Dumeige]

Hello,

The system has no CPU resource left, you need to check if this is an issue by looking at the load average or the Run Q length.

You have large %sys consumption but %wio is still low, it seems the I/O are not an issue. But if you have 50 process waiting on the CPU, that's no good.
Check vmstat output to find out more info ( or sar / glance if you're more confortable with it).

If the server is dedicated to Oracle, consider using statpack to check the instance health.

Cheers

Nicolas

[Kent Ostby]

One issue that I have seen with oracle performance and high CPU usage is the ratio of RAM to device swap.

I've seen a couple of systems that were completely hung where the fix was to make the device swap 3x RAM on a heavy usage oracle system.

Best regards,

Kent M. Ostby