- 论坛徽章:
- 1
|
环境描述:
有业务的机器:rhel6.3 oracle两节点rac 11.2.0.4.4 64GB mem load average: 0.73, 0.78, 0.73,两节点的load都低
======================================================
top - 14:52:59 up 4 days, 1:45, 2 users, load average: 0.89, 0.83, 0.76
Tasks: 911 total, 1 running, 910 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.3%us, 1.2%sy, 0.0%ni, 95.3%id, 0.1%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 65932232k total, 34439472k used, 31492760k free, 369992k buffers
Swap: 33038328k total, 1544k used, 33036784k free, 27416584k cached
=================================================
cat /proc/cpuinfo | grep "physical id" | sort | uniq
physical id : 0
physical id : 1
cat /proc/cpuinfo | grep "cores" | uniq
cpu cores : 6
cat /proc/cpuinfo | grep "processor" | wc -l
24
cat /proc/cpuinfo | grep "siblings" | sort | uniq
siblings : 12
cat /proc/cpuinfo | grep "model" | sort | uniq
model : 62
model name : Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz
================================
该系统已经有业务运行,dbtime平均在70min左右
SQL> select status,count(*) from v$session group by status;
STATUS COUNT(*)
-------- ----------
ACTIVE 57
INACTIVE 153
===================================
vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id wa st
3 1 1544 31431304 369624 27405288 0 0 99 101 5 4 4 1 95 0 0
1 0 1544 31425468 369624 27405328 0 0 92 1245 10115 12181 8 1 91 0 0
3 0 1544 31427452 369624 27405328 0 0 123 1198 8782 11808 3 1 96 0 0
2 0 1544 31420668 369624 27405328 0 0 67 869 11415 14706 4 2 94 0 0
0 1 1544 31417188 369624 27405344 0 0 139 1904 10876 14524 3 2 95 1 0
0 0 1544 31414260 369624 27405344 0 0 227 1415 9242 13035 3 1 96 0 0
3 0 1544 31422668 369624 27405484 0 0 139 535 10440 11430 4 2 94 0 0
1 0 1544 31423632 369628 27405560 0 0 51 1006 9064 11408 4 1 95 0 0
0 0 1544 31423820 369628 27405492 0 0 195 977 10197 12614 3 1 96 0 0
0 0 1544 31439328 369628 27405508 0 0 115 871 10817 13771 4 2 94 0 0
1 0 1544 31439204 369628 27405508 0 0 51 1520 8037 10882 2 1 97 0 0
===================================================
无业务的机器: rhel6.7 oracle两节点rac 11.2.0.4.160719 64GB mem load average: 1.07, 1.12, 1.14 ,有时能到2,两节点的loade都是1以上
=========================================
top - 14:50:46 up 4:37, 3 users, load average: 1.20, 1.16, 1.15
Tasks: 790 total, 1 running, 789 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.4%us, 0.3%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 65838380k total, 41103652k used, 24734728k free, 131640k buffers
Swap: 33554684k total, 0k used, 33554684k free, 1048780k cached
=====================================================
cat /proc/cpuinfo | grep "physical id" | sort | uniq
physical id : 0
physical id : 1
cat /proc/cpuinfo | grep "cores" | uniq
cpu cores : 8
cat /proc/cpuinfo | grep "processor" | wc -l
32
cat /proc/cpuinfo | grep "siblings" | sort | uniq
siblings : 16
cat /proc/cpuinfo | grep "model" | sort | uniq
model : 63
model name : Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
============================================
SQL> select status,count(*) from v$session group by status;
STATUS COUNT(*)
-------- ----------
ACTIVE 46
INACTIVE 2
================================================
vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id wa st
0 0 0 24735652 131796 1049268 0 0 3 3 29 27 1 0 99 0 0
0 0 0 24735948 131800 1049264 0 0 83 237 6837 9231 0 1 99 0 0
0 0 0 24736152 131800 1049516 0 0 99 34 5343 8568 0 0 100 0 0
2 0 0 24735880 131800 1049516 0 0 35 29 4781 7471 0 0 100 0 0
0 0 0 24735796 131800 1049524 0 0 707 2 5212 8212 0 0 99 0 0
0 0 0 24735500 131800 1049524 0 0 99 45 5613 8031 0 0 99 0 0
0 0 0 24736580 131812 1049512 0 0 19 86 6937 9363 0 1 99 0 0
0 0 0 24736688 131812 1049512 0 0 35 1 5305 8504 0 0 100 0 0
3 0 0 24736464 131812 1049524 0 0 51 34 4740 7473 0 0 100 0 0
2 0 0 24737108 131812 1049524 0 0 19 29 4905 8164 0 0 100 0 0
3 0 0 24738176 131812 1049524 0 0 35 2 5712 8129 0 0 99 0 0
0 0 0 24744020 131816 1049524 0 0 83 61 6942 9357 0 1 99 0 0
1 0 0 24743680 131816 1049524 0 0 35 30 5571 8797 0 0 99 0 0
0 0 0 24743804 131816 1049524 0 0 51 1 4946 7722 0 0 100 0 0
1 0 0 24744672 131816 1049528 0 0 19 34 4899 8293 0 0 100 0 0 |
|