Home » Infrastructure » Unix » High iowait on AIX (Oracle,9i(9.8.0.2),AIX 5.3)
High iowait on AIX [message #401177] Sat, 02 May 2009 00:07 Go to next message
mohsinsalam
Messages: 7
Registered: January 2006
Junior Member
Hi all,
following out put of iostat showing hi iowait, due this i am facing some problem when i get the data from SAN, i am useing oracle 9i(9.8.0.2) with erp application can any on let me know the solution for the iowait issue b/c i am new in AIX
thanks in advance.
singerdb1:/>iostat 5 10

System configuration: lcpu=4 drives=9 paths=2 vdisks=0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 11.6 0.7 0.2 46.8 52.3

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 0.0 0.0 0.0 0 0
hdisk0 0.0 1.6 0.4 8 0
dac2 0.0 0.0 0.0 0 0
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.0 0.0 0.0 0 0
hdisk3 0.0 0.0 0.0 0 0
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 153.9 0.3 0.2 47.1 52.5

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 0.0 0.0 0.0 0 0
hdisk0 0.0 0.8 0.2 4 0
dac2 0.0 0.0 0.0 0 0
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.0 0.0 0.0 0 0
hdisk3 0.0 0.0 0.0 0 0
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 218.8 0.5 0.6 46.7 52.2

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 2.0 9.6 2.4 0 48
hdisk0 0.0 9.6 2.4 0 48
dac2 0.0 0.0 0.0 0 0
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.0 0.0 0.0 0 0
hdisk3 0.0 0.0 0.0 0 0
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 154.4 1.0 0.7 60.4 38.0

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 36.0 290.2 67.0 148 1303
hdisk0 26.0 305.4 71.2 224 1303
dac2 0.0 124.8 21.6 132 492
dac2utm 0.0 0.0 0.0 0 0
hdisk2 2.0 38.4 7.2 36 156
hdisk3 2.0 86.4 14.4 96 336
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 151.4 0.8 0.8 84.5 13.8

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 87.1 628.0 149.5 0 3201
hdisk0 72.8 628.7 149.7 0 3205
dac2 0.0 72.2 12.6 60 308
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.2 7.1 1.8 12 24
hdisk3 0.0 65.1 10.8 48 284
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 154.2 2.1 1.4 84.2 12.4

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 82.1 684.0 161.6 0 3425
hdisk0 90.9 683.2 161.4 0 3421
dac2 0.0 143.0 29.0 168 548
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.4 76.7 16.2 108 276
hdisk3 0.2 66.3 12.8 60 272
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 156.6 1.2 0.9 86.0 11.9

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 86.0 720.7 168.6 0 3553
hdisk0 95.5 720.7 168.6 0 3553
dac2 0.0 94.9 17.6 84 384
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.0 24.3 5.5 36 84
hdisk3 0.2 70.6 12.2 48 300
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 151.0 0.9 0.9 84.2 14.0

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 86.3 630.8 147.5 0 3225
hdisk0 68.3 631.6 147.7 4 3225
dac2 0.0 92.3 15.6 84 388
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.0 16.4 2.9 24 60
hdisk3 0.0 75.9 12.7 60 328
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 153.7 0.9 0.4 98.6 0.1

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 0.0 0.0 0.0 0 0
hdisk0 0.0 0.0 0.0 0 0
dac2 0.0 70.1 12.3 60 292
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.0 14.3 3.0 12 60
hdisk3 0.0 55.7 9.4 48 232
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0

tty: tin tout avg-cpu: % user % sys % idle % iowait
0.0 156.7 0.9 0.5 98.5 0.1

Disks: % tm_act Kbps tps Kb_read Kb_wrtn
hdisk1 0.0 0.0 0.0 0 0
hdisk0 0.0 0.0 0.0 0 0
dac2 0.0 87.7 16.4 84 348
dac2utm 0.0 0.0 0.0 0 0
hdisk2 0.0 24.4 5.5 36 84
hdisk3 0.0 63.3 11.0 48 264
hdisk4 0.0 0.0 0.0 0 0
hdisk5 0.0 0.0 0.0 0 0
cd0 0.0 0.0 0.0 0 0
singerdb1:/>

regards
Mohsin Salam
Re: High iowait on AIX [message #401209 is a reply to message #401177] Sat, 02 May 2009 10:56 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

>following out put of iostat showing hi iowait,
High relative to what baseline?

The reality is the only way to reduce IOWAIT times is to add additional physical disks to reduce activity to each device.
IO operations must occur for DB to function & physics applies.
Previous Topic: old school clone from Solaris 8 to solaris 10
Next Topic: Run shell Script from a procedure
Goto Forum:
  


Current Time: Thu Mar 28 09:05:52 CDT 2024