File I/O and TableSpace I/OIf the value for Avg Blks/Rd is higher than 1, this indicates full table
scans. If it grows higher than Note that increasing the Average Read Times (AvgRd) of greater than 20..40ms should be considered slow for single block reads. So if this is the case, you should check whether the disks are capable of the required IO rates. If they are, your file-to-disk layout may be causing some disks to be underused while others are overly busy. Furthermore, if the temporary TableSpaces have the most write activity, this may indicate that too much of the sorting is to disk and may require optimization. |