4 CPU,rhel 5 + oracle10gr2 OLAP
昨天linux重启一次后,oracle进程的cpu使用率一直上不去,大查询和过程一直在跑,但无法获得足够的CPU资源,速度极其缓慢,idle值基本在百分之50以上
怀疑是os层面出了什么问题
top - 19:37:56 up 1 day, 5:15, 3 users, load average: 13.72, 13.93, 13.65
Tasks: 174 total, 1 running, 173 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.8%us, 0.5%sy, 0.0%ni, 49.0%id, 45.7%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8107008k total, 8090504k used, 16504k free, 44972k buffers
Swap: 10241396k total, 37028k used, 10204368k free, 7253096k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5040 oracle 16 0 3470m 1.4g 1.4g S 9 18.5 2:01.54 oracle
5038 oracle 15 0 3470m 1.4g 1.4g D 8 18.5 2:01.14 oracle
5025 oracle 16 0 3470m 1.3g 1.3g S 1 16.8 0:05.30 oracle
5042 oracle 15 0 3478m 1.8g 1.7g D 1 22.7 1:19.27 oracle
5044 oracle 16 0 3472m 1.7g 1.7g S 1 22.6 1:19.97 oracle
5062 oracle 18 0 3468m 1.4g 1.4g D 1 17.7 0:04.73 oracle
5034 oracle 15 0 3474m 1.4g 1.4g D 0 18.7 0:09.96 oracle
5036 oracle 16 0 3469m 1.4g 1.4g S 0 18.6 0:09.80 oracle
5503 oracle 16 0 3469m 386m 381m D 0 4.9 0:00.59 oracle
5510 oracle 15 0 3468m 514m 511m S 0 6.5 0:01.69 oracle
1 root 15 0 10324 692 580 S 0 0.0 0:01.49 init
[oracle@b2b ~]$ vmstat -n 10
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
0 13 37036 16364 45612 7254528 0 0 1882 696 31 19 16 1 57 26 0
0 13 37036 16128 45608 7254776 0 0 2616 163 378 692 1 0 74 25 0
3 14 37036 16848 45608 7254024 0 0 2333 197 357 639 1 0 69 30 0
0 14 37036 16660 45580 7254152 0 0 2540 219 361 622 1 0 73 26 0
0 12 37036 16296 45568 7254712 0 0 2684 167 398 716 1 0 72 26 0
1 13 37036 16108 45564 7254888 0 0 2577 281 379 698 1 0 72 27 0
1 12 37036 16224 45524 7254568 0 0 2473 189 343 581 1 0 70 28 0
0 14 37036 16460 45520 7254388 0 0 2460 197 383 700 2 0 71 27 0
0 14 37036 17480 45484 7253620 0 0 2240 143 328 557 1 0 75 24 0
0 13 37032 15432 45532 7255344 0 0 1903 264 366 652 2 0 73 26 0
1 13 37032 17888 45468 7252944 0 0 2981 171 394 712 2 0 68 30 0
0 13 37032 15480 45476 7255528 0 0 2043 288 374 595 3 0 62 35 0
0 14 37032 16008 45464 7254812 0 0 2245 303 390 661 3 0 62 35 0
0 13 37032 16780 45432 7254180 0 0 2231 249 343 598 3 0 70 28 0
1 14 37032 17256 45432 7253796 0 0 2400 251 392 698 2 0 71 27 0
0 14 37032 17852 45392 7253116 0 0 2384 197 392 659 1 0 67 32 0
0 13 37032 15504 45428 7255436 0 0 2068 275 356 624 2 0 72 26 0
0 13 37032 16340 45380 7254596 0 0 2249 191 348 598 1 0 73 25 0
0 14 37032 17236 45376 7253820 0 0 2236 199 385 662 2 0 65 33 0
0 14 37032 17892 45388 7253044 0 0 2259 236 354 611 1 0 73 26 0