Indunil Jayasooriya wrote:

Hi All,

I am learning iostat command to understand disk I/O statistics.

We have 2 Centos 4 servers running where oracle is installed.We installed them 2 weeks ago. @ that time, These Servers performed well. But, Now We have come to know that these 2 Machines are quite slow when comparing to the first week.

So, Some say, run iostat to see statictics. I am not familiar with comamnd well.

I found below url

http://www.redhat.com/docs/manuals/enterprise/RHEL-4-Manual/admin-guide/s1-r...

as the page says, `man iostat` for more information

i typically run something like

# iostat -x 5

and ignore the first sample.. every 5 seconds this will output information on disk IO by drive volume. I find the await a particularly important, as its the amount of time disk IO operations are staying queued waiting for the drive, if this gets up tnio the 1000mS range you have a serious bottleneck

you said Oracle. to manage and maintain a production Oracle database server, you need an experienced Oracle Data Base Administrator ("DBA") who can optimize and tune and maintain the database. such a person will be very familiar with tracking query and tablespace IO statistics, identifying bottlenecks and restructuring things to achieve optimal performance