AIX - % OF IO WAIT IS TOO HIGHT
360194Feb 20 2008 — edited Feb 26 2008I have performance problems on my RAC Database 10.2.0.3 (AIX 5.2) - 2 Nodes.
A table with 30.000.000(3GB) of records, partition by year.
When execute Select on this table in production enviroment(Suse Sles9 - Non Rac) this return in 5 seconds. In a Rac
enviroment this return in 59 secons.
before select:
sar -u 1 3
18:14:48 %usr %sys %wio %idle
18:14:48 0 0 0 100
18:14:49 0 0 0 100
18:14:50 0 0 0 100
during select:
sar -u 1 3
18:15:00 %usr %sys %wio %idle
18:15:01 32 4 80 20
18:15:02 24 8 78 22
18:15:03 50 6 90 10