EM12c - Calculating Average I/O Read time
We are running EM 12cR3 and monitoring many 11gR2 databases and our database storage is on a big Netapps system. If there are issues with our storage system, it negatively impacts our database performance. In an AWR report, there is a column in the Tablespace I/O Stats and File I/O Stats sections of the AWR which reports the average read time in mili-seconds. Is there a comparable metric with EM which we could track and perhaps alert on?
If not, is there some other way to monitor the good-ness of the I/O system?
Stephen Murphy, DBA
University at Albany, SUNY