Now I am going to get a report on the database performance. I know bstat/estat, or statspack. But these tools just take the snapshots at the beginning and the end. What I want to get is the I/O performance, real track of the I/O performance, not just the statistics from the beginning to the end.
Any info will be appreciated!!
It's not cheap, but "Oracle High Performance Tuning with STATSPACK" by Donald K Burleson contains scripts to extend STATSPACK to include OS stats via the vmstat and iostaty commands. Obviously, this won't be much good if you're not on UNIX/Linux.