Getting specific section from AWR report
Hello,
I am on 11.2.0.3 database. I am trying to get the I/O statistics from the database - especially average read time and total physical reads per hour. i.e. I want to get only following 2 sections from an AWR report for every hour (hourly snapshots). I DO NOT want the whole AWR report. Is there any way to get this? Can I run a query on the sys.wrh$_% tables to get this information?
Tablespace IO Stats
File IO Stats
Thank you.