周一一大早就发现一个数据库负载超高,性能异常:
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
|
应用的问题太多了,汗!
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
