« 欢迎加入ChinaOracleBlogger地图 |
Blog首页
| EMC Soft/Hard Read/Write Errors »
CPU Load Very High-超高负载之数据库
作者：
eygle |【转载时请以超链接形式标明文章
出处和作者信息及
本声明】
链接：
http://www.eygle.com/archives/2006/01/cpu_load_very_high.html
周一一大早就发现一个数据库负载超高,性能异常:
4CPU,8G内存,的SUN Fire 480R主机:
# ./prtdiag
System Configuration: Sun Microsystems sun4u Sun Fire 480R
System clock frequency: 150 MHz
Memory size: 8192 Megabytes
========================= CPUs ===============================================
Run E$ CPU CPU
Brd CPU MHz MB Impl. Mask
--- ----- ---- ---- ------- ----
A 0 1050 8.0 US-III+ 11.0
A 2 1050 8.0 US-III+ 11.0
B 1 1050 8.0 US-III+ 11.0
B 3 1050 8.0 US-III+ 11.0
|
现在负载:
load averages: 13.12, 12.60, 12.23 db480-4.hurray.com.cn 09:50:32
184 processes: 166 sleeping, 12 running, 1 stopped, 5 on cpu
CPU states: 0.0% idle, 93.6% user, 6.4% kernel, 0.0% iowait, 0.0% swap
Memory: 8.0G real, 2.8G free, 4.1G swap in use, 18.1G swap free
PID USERNAME THR PR NCE SIZE RES STATE TIME FLTS CPU COMMAND
11834 oracle 2 22 0 3.1G 3.0G run 12:51 0 7.08% oracle
3876 oracle 2 22 0 3.1G 3.0G run 38.5H 0 6.93% oracle
15876 oracle 2 21 0 3.1G 3.0G run 514:20 0 6.85% oracle
4042 oracle 2 21 0 3.1G 3.0G run 41.3H 0 6.78% oracle
29532 oracle 2 21 0 3.1G 3.0G run 19.4H 0 6.67% oracle
3703 oracle 2 21 0 3.1G 3.0G run 38.5H 0 6.66% oracle
29704 oracle 2 21 0 3.1G 3.0G run 20.9H 0 6.60% oracle
15537 oracle 2 21 0 3.1G 3.0G run 496:48 0 6.57% oracle
15680 oracle 2 31 0 3.1G 3.0G run 496:44 0 6.50% oracle
29375 oracle 2 31 0 3.1G 3.0G run 19.5H 0 6.31% oracle
4033 oracle 2 22 0 3.1G 3.0G run 8:51 0 4.76% oracle
4035 oracle 2 51 0 3.1G 3.0G sleep 8:55 0 4.70% oracle
4046 oracle 2 52 0 3.1G 3.0G cpu03 8:59 0 4.68% oracle
7349 oracle 11 53 0 3.1G 3.0G sleep 8:38 0 4.44% oracle
4055 oracle 2 42 0 3.1G 3.0G cpu02 8:43 0 4.39% oracle
|
应用的问题太多了,汗!
By eygle on 2006-01-09 10:30 |
Comments (2) |
Posted to
Case | Edit |
搜索本站:
Posted by: anysql at January 9, 2006 9:15 PM
Posted by: eygle at January 9, 2006 9:31 PM
发表留言:
