-
database performance
Hi,
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!!
Thanks.
-
have you looked as o/s level tools? vmstat and sar on unix, or windows tools?
-
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.
-
look at Oracle 92 diagnostics pack, u can collect OS stats from there
-
You can query V$FILESTAT to know about datafiles I/O perf.
This view has great in-depth statistics with respect to the datafiles I/O.
-
Oracle enterprise manager has tools for this