The I/O Times tab on the Tablespace Analysis drilldown contains graphs that let you visually monitor average I/O times and buffer pool hit ratios for a tablespace. The four graphs track the following:
Average amount of time spent on direct I/O.
Average amount of time spent on asynchronous I/O.
Average amount of time spent on physical I/O.
Buffer pool hit ratios.
All four graphs use counter data to show statistics as they change over time. This allows you to see when average I/O times are high and buffer pool hit ratios are low for a tablespace.
Consistently high I/O times can be a symptom of I/O conflict. Consistently low hit ratios can be a sign that a buffer pool is not operating efficiently. Both problems degrade performance. To identify applications that are contributing to I/O conflict, work from the Client Application Analysis drilldown. To investigate buffer pool conditions, work from the Buffer Pool Analysis drilldown.
Click the links below to see descriptions of each graph in the I/O Times tab:
As you view graphs in the I/O Times tab, you can click icons in graph toolbars to:
Copy graph details to the clipboard
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
