iostat output

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Wed, 28 Apr 2004 17:10:04 -0700 (PDT)
Message-ID: <20040429001004.70877.qmail@web80406.mail.yahoo.com>

the following is the o/p of iostat on a new configured machine with netapp filer over icsci running oracle 9i database(1 tb in size).

Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util

sda      807.31   2.99 252.82  1.33 8486.38   34.55    33.53     8.50   33.07   5.23  13.29
sda1     807.31   2.99 252.82  1.33 8486.38   34.55    33.53     8.50   33.07   5.23  13.29
sdb  2791.03   0.33 1055.81  3.99 30790.70   34.55    29.09    44.12   41.13   8.03 85.05
sdb1 2791.03   0.33 1055.81  3.99 30790.70   34.55    29.09    44.12   41.13   8.03 85.05
sdc        0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00    0.00   0.00   0.00
sda  6446.67   3.00 1444.00  1.33 63122.67   34.67    43.70    91.73   63.49   6.90  99.67
sda1 6446.67   3.00 1444.00  1.33 63122.67   34.67    43.70    91.73   63.49   6.90 99.67

sdb 2137.67 0.33 587.33 2.33 21826.67 21.33 37.05 32.13 54.78 13.23 78.00 sdb1 2137.67 0.33 587.33 2.33 21826.67 21.33 37.05 32.13 54.78 13.23 78.00 sdc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda 682.67 2.00 201.67 1.33 7080.00 34.67 35.05 14.90 73.23 14.61 29.67 sda1 682.67 2.00 201.67 1.33 7080.00 34.67 35.05 14.90 73.23 14.61 29.67 sdb 11828.67 0.00 2243.33 1.67 112573.33 13.33 50.15 125.23 55.68 4.45 100.00
sdb1 11828.67 0.00 2243.33 1.67 112573.33 13.33 50.15 125.23 55.68 4.45 100.00 sdc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda 1878.33 3.00 480.33 1.00 18864.00 32.00 39.26 36.10 75.07 20.43 98.33 sda1 1878.33 3.00 480.33 1.00 18864.00 32.00 39.26 36.10 75.07 20.43 98.33 sdb 11763.33 0.00 1908.00 1.00 109365.33 8.00 57.29 129.90 68.20 5.24 100.00 sdb1 11763.33 0.00 1908.00 1.00 109365.33 8.00 57.29 129.90 68.20 5.24 100.00 sdc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

i have bolded the avrg wait,srvc time and % utilization and i think given the above stats the i/o is bad on this configuration. the wait times are very high and there is a problem with the way physical configuration of the disks is done and how the datafiles are laid out.

please advise me on this and explain whether my observation is alright. and also tell me what could be a reason for this to happen.

thanks
sai

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Apr 28 2004 - 19:07:01 CDT