On Fri, Aug 20, 2010 at 4:14 PM, Brian Mathis <brian.mathis@xxxxxxxxx> wrote:
> On Fri, Aug 20, 2010 at 2:48 PM, Ed Donahue <liberaled@xxxxxxxxx> wrote:
>> We are currently running CentOS 5 update 4 on a Dell R910 server 16
>> cores/32 hyperthreaded with 64GB of memory. It is our main Oracle 11g
>> DB server for one of our customers and is attached to an MD 3000
>> storage array. We are having a load averaging around 5 but see no swap
>> in use, CPUs are pretty much idle and no I/O wait. We have Oracle
>> dataguard turned on in transactional mode. I've checked everything
>> that I can think of, there are no Oracle processes running which would
>> cause a spike. Anyone have any ideas as to what to check next?
>>
>> I have another R910 configured the same way and do not see any issues
>> with the 3 databases running on that server. The load is at .5.
>
> Do you have sar (sysstat) installed and running? That will gather
> stats 1x per minute on the server and you can see more than what a
> typical 'top' will show you. You can also graph the output using
> ksar, which will make it easier to see things.
> _______________________________________________
> CentOS mailing list
> CentOS@xxxxxxxxxx
> http://lists.centos.org/mailman/listinfo/centos
>
sar is showing a 99.6% idle cpu, this box only has an oracle db running on it.
It has dataguard which keeps it in sync with the DR server over a vpn.
Here is vmstat output:
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
1 0 0 50057932 28332 13016296 0 0 1 6 0 0
0 0 100 0 0
0 0 0 50058992 28348 13016292 0 0 0 180 1172 2660
0 0 100 0 0
0 0 0 50059156 28356 13016300 0 0 0 192 1250 3071
0 0 100 0 0
0 0 0 50059988 28372 13016300 0 0 0 50 1221 3074
0 0 100 0 0
0 0 0 50060244 28380 13016292 0 0 0 126 1057 2578
0 0 100 0 0
No processes in D status or zombies
The NFS mounts are fine too, only two of them and they have users home
directories and no one logged onto the system.
It is also hooked up to a MD3000 where the db and oracle files are
stored, the md3000 isn't showing any alerts.
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
