Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Iīve a system running Oracle IAS. I see that %sys is greater that used %user when I do a iostat.
I suppose that itīs a problem of memory. So if I increase the amount of memory the %sys will decrease, but Iīm not sure. Oracle IAS allways uses all memory of the system so Mem: parameters have to be read carefully.
How can i be sure that the problem is due to lack of memory and that increasing memory will decrease %system. I donīt want to buy the memory if not necesary.
At this moment, pararamteres ar low due to there are few users, but they use to be greater.
You say there is a problem but looking at your iostat figures I don't see any problem. The only thing that catches my attention is the number of processes. (480) But I haven't run Oracle so I don't know if that is expected or not.
Your overall workload hovers around 1.0 but since you have 4 CPUs the theoretical full workload would be 4.0. So it looks like you could quadruple the CPU workload without straining the operating system.
All of your CPUs spend most of their time idling.
You are using 500 MB of your swap file. Your total swap file size is 2 GB. No problem there.
The RAM figures are pretty typical of Linux. You say that Oracle uses all available RAM. Linux does the same thing with or without Oracle. No problem there.
The iowait for each CPU is less than 2%. No problem there.
The system CPU time is less than 33% for each CPU. No problem there.
The user CPU time is less than 15% for each CPU. No problem there. The ratio of user time to system time is irrelevant. That is determined by your workload. There is no right or wrong. You just have to figure what you should expect to see for a given workload and compare that to what you actually see. In this case the fact that the system spends twice as much time in system mode as in user mode does not indicate a problem. Remember that a database server is going to spend a lot of time managing locks and data accesses, both of which are CPU intensive.
I really don't think that you have a problem. If you want to add more work to the system then the only area that you might want to change is to add RAM. I say that because you are already swapping under the current workload. Otherwise the CPU and the i/o are ready to do more work than you currently give them.