You were brought to this page based on an internet search
and as a free service to Oracle DBAs.
The text below is an except from the book,
Oracle Performance Firefighting, written by
Craig Shallahamer of
OraPub, Inc.
Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click
here.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
-------------------------------
* w/s: This is the number of write requests submitted to the device per second. My testing shows good write-per-second correlation with Oracle, when adding together the database writer IO operations from the v$filestat column phywrts and log writer requests from the v$sysstat statistic redo_writes. It is troubling, however, that adding all wait event write-related occurrences fell well short of the actual iostat r/s and v$filestat and v$systats numbers.
* await: This is the average IO request response time in milliseconds. While clearly mislabeled, the manual page and observations show the await column includes both the true service time and queue time. Before I begin an IO analysis or make this statement to a customer, I always double-check the manual page for the particular Linux or Unix implementation. Again, my rule of thumb for acceptable response time is 10 ms.
* %util: This is the average device utilization. Modern IO subsystems can sustain utilizations up to and possibly over 65%. While I use a high utilization to spot potential issues, I also make sure the response time is an issue before claiming there is a problem. I have seen devices 90% busy and still servicing IO requests in under 5 ms. The arrival pattern and IO request service time play a significant role in the resulting device utilization.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
|