我的环境:red hat as4 +oracle10.2
数据库很慢,
top:
top - 14:53:18 up 9 days, 23:52, 1 user, load average: 8.41, 8.68, 9.17
Tasks: 164 total, 2 running, 162 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.0% us, 0.7% sy, 0.0% ni, 24.2% id, 73.8% wa, 0.3% hi, 0.0% si
Mem: 2071560k total, 2055308k used, 16252k free, 5064k buffers
Swap: 12924284k total, 26784k used, 12897500k free, 1529800k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
27787 oracle 15 0 1117m 594m 592m D 1 29.4 0:07.62 oracle
27936 oracle 16 0 3064 1012 768 R 1 0.0 0:04.41 top
28047 oracle 15 0 1117m 342m 340m R 1 16.9 0:02.65 oracle
4710 oracle 15 0 1141m 959m 939m D 0 47.5 36:23.80 oracle
26956 oracle 16 0 1118m 254m 252m S 0 12.6 1:04.82 oracle
27330 oracle 15 0 1117m 48m 45m S 0 2.4 0:00.36 oracle
27448 oracle 15 0 1117m 879m 877m D 0 43.5 0:13.17 oracle
27864 oracle 15 0 1117m 522m 520m S 0 25.8 0:06.04 oracle
27994 oracle 15 0 1117m 304m 302m S 0 15.0 0:03.11 oracle
1 root 16 0 2404 552 472 S 0 0.0 0:16.88 init
2 root RT 0 0 0 0 S 0 0.0 0:00.55 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.33 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:00.01 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/1
8 root 7 -10 0 0 0 S 0 0.0 0:00.00 khelper
发现73.8% wa很高,怎么查询高io的process?多谢!