In AWR, check for the columns Tablespace I/O stats and File I/O stats.
In Tablespace I/O, see the avg(ms). If it is > 20, we may have to take some initiative.
In File I/O stats, if the Reads column shows more value, then we can try to change the mount point.
No comments:
Post a Comment