-
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
I'm stmontgo and I approve of this message
-
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
Cheers
Murali
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|