Sponsored Content
Operating Systems AIX CPU Load balancing in AIX 5.2, Oracle Post 302631733 by ucbus on Friday 27th of April 2012 08:39:41 PM
Old 04-27-2012
CPU Load balancing in AIX 5.2, Oracle

I am neither a DBA nor an AIX spcialist. We are running Oralce 11G on P5, AIX5.3.
Per Oracle reports we are using 16 CPUs and 8 cores. However when I am looking at nmon report I find the cpu utilization is not load balanced.

Code:
CPU_SUMM	User%	Sys%	Wait%	Idle%
xxx001	 74.2	23.6	1.0	1.3
xxx002	 71.1	10.1	1.9	16.9
xxx003	 85.0	13.9	0.5	0.7
xxx004	 73.9	9.9	1.3	14.9
xxx005	 82.4	10.9	0.5	6.2
xxx006	 68.8	11.2	1.0	19.0
xxx007	 31.2	20.6	0.1	48.1
xxx008	 17.0	27.2	0.2	55.6
xxx009	 0.0	30.1	0.0	69.9
xxx010	 0.0	28.7	0.0	71.3
xxx011	 0.0	27.7	0.0	72.2
xxx012	 0.0	31.2	0.0	68.8
xxx013	 0.0	28.8	0.0	71.2
xxx014	 0.0	32.8	0.0	67.1
xxx015	 0.0	27.3	0.0	72.6
xxx016	 0.1	33.7	0.0	66.2

As you can see we are having some processors experiencing wait time where as some are idling. My question is simple:Are we not supposed to have some load balancing in place that would take care of the above imbalances? A more advanced question would be: What do I need to set in ORACLE/AIX to make the above a more uniformly load balanced system.

Last edited by Scrutinizer; 04-28-2012 at 05:26 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Question about load balancing

If you have two or more servers load balancing, are the servers mirroring one another? If images, etc., are uploaded, will they be stored on all the servers so that if one server goes down, the images will be served up by another server? (1 Reply)
Discussion started by: wvmlt
1 Replies

2. AIX

idea on hacmp load balancing

Hi All, Any idea about load balancing on hacmp? Or load balancing is only on lpar. Any idea or link info will do. Thanks in advance. (2 Replies)
Discussion started by: itik
2 Replies

3. Ubuntu

perlbal and load balancing

Hi guys, I wonder if someone would be able to assist with my problem. I have just set up a load balancer for a company I am working for. HTTP redirection is working fine, however they also want to load balance SSH and FTP too. At the moment the perlbal config looks like; CREATE POOL webhttp ... (1 Reply)
Discussion started by: JayC89
1 Replies

4. Solaris

Load balancing with IPMP

Is it possible to do a load balancing ( incoming and outgoing )with with IPMP in solaris 10 like sun trunking ? If yes what are the steps involved in it , i know how to do the failover IPMP both link based and probe based but i 'm looking for possible load balancing (3 Replies)
Discussion started by: fugitive
3 Replies

5. Web Development

Load Balancing in Apache

Hi All, I have one webserver which has an application for a set of internal users can be accessed by _http://server1.com I am planning to load balance this application. For that I have cloned this server and build a new one which can be accessed using _http://server2.com]Server2.com. Also i... (2 Replies)
Discussion started by: Tuxidow
2 Replies

6. Linux

HTTP load balancing.

Hi, We have 2 pools of servers. Lets call them A and B and they would contain 2 servers each. Pool A will be hosting www.example.com/app/v1 and pool B will be hosting www.example.com/app/v2. Clients will be requesting right url (/v1 or /v2) but will be hitting just one IP. I'd like to: 1)... (3 Replies)
Discussion started by: chrisfb
3 Replies

7. IP Networking

Load Balancing ppp

Hello everybody How can i Load Balance two slow ppp(gprs) connections with iptables . (4 Replies)
Discussion started by: rink
4 Replies

8. UNIX for Advanced & Expert Users

Help in MQ load balancing

Hi, Currently we have 3 old and 3 new servers catering to Live traffic. As my component move from legacy interfaces to MQ one, we want to have load balancing of old interfaces available on MQ interface as well. For this, we want to send only 30% of all MQ traffic on 3 OLD Live servers, and want... (1 Reply)
Discussion started by: senkerth
1 Replies

9. UNIX for Advanced & Expert Users

Load balancing in Autosys

Hi, I am working on development project where I have to migrate many jobs from Tidal to Autosys R11. During this project we came across the following requirements. 1. There are 3 real machines. There could be many jobs activated simultaneously, but only one job should execute at a time and... (0 Replies)
Discussion started by: sujeetp
0 Replies

10. Shell Programming and Scripting

Load Balancing in UNIX

Dear All, Can any one help me for this request? There is a case. I have 20 files which I need to FTP to 5 servers. I want to know if there is any possibility to make a load balancer which transfers files in round robin manner to 5 servers. As per theoretical algorithm, what I think, flow can... (9 Replies)
Discussion started by: Zaib
9 Replies
Sys::Statistics::Linux::CpuStats(3pm)			User Contributed Perl Documentation		     Sys::Statistics::Linux::CpuStats(3pm)

NAME
Sys::Statistics::Linux::CpuStats - Collect linux cpu statistics. SYNOPSIS
use Sys::Statistics::Linux::CpuStats; my $lxs = Sys::Statistics::Linux::CpuStats->new; $lxs->init; sleep 1; my $stats = $lxs->get; Or my $lxs = Sys::Statistics::Linux::CpuStats->new(initfile => $file); $lxs->init; my $stats = $lxs->get; DESCRIPTION
Sys::Statistics::Linux::CpuStats gathers cpu statistics from the virtual /proc filesystem (procfs). For more information read the documentation of the front-end module Sys::Statistics::Linux. CPU STATISTICS
Generated by /proc/stat for each cpu (cpu0, cpu1 ...). cpu without a number is the summary. user - Percentage of CPU utilization at the user level. nice - Percentage of CPU utilization at the user level with nice priority. system - Percentage of CPU utilization at the system level. idle - Percentage of time the CPU is in idle state. total - Total percentage of CPU utilization. Statistics with kernels >= 2.6. iowait - Percentage of time the CPU is in idle state because an I/O operation is waiting to complete. irq - Percentage of time the CPU is servicing interrupts. softirq - Percentage of time the CPU is servicing softirqs. steal - Percentage of stolen CPU time, which is the time spent in other operating systems when running in a virtualized environment (>=2.6.11). METHODS
new() Call "new()" to create a new object. my $lxs = Sys::Statistics::Linux::CpuStats->new; Maybe you want to store/load the initial statistics to/from a file: my $lxs = Sys::Statistics::Linux::CpuStats->new(initfile => '/tmp/cpustats.yml'); If you set "initfile" it's not necessary to call sleep before "get()". It's also possible to set the path to the proc filesystem. Sys::Statistics::Linux::CpuStats->new( files => { # This is the default path => '/proc' stat => 'stat', } ); init() Call "init()" to initialize the statistics. $lxs->init; get() Call "get()" to get the statistics. "get()" returns the statistics as a hash reference. my $stats = $lxs->get; raw() Get raw values. EXPORTS
No exports. SEE ALSO
proc(5) REPORTING BUGS
Please report all bugs to <jschulz.cpan(at)bloonix.de>. AUTHOR
Jonny Schulz <jschulz.cpan(at)bloonix.de>. COPYRIGHT
Copyright (c) 2006, 2007 by Jonny Schulz. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2012-03-09 Sys::Statistics::Linux::CpuStats(3pm)
All times are GMT -4. The time now is 11:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy