OT: My weekly post: runstats to test fastly modification
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Apr 2004 18:27:07 -0400
There is an interesting utility to test fastly two differect solutions
1.1 Tom Kyte’s Runstats: To compare two solutions
This tool allows you easily to compare two distinct solutions.
Don’t forget to run once every one before executing the comparison, because
in the first time always usually there is first parsing and disk reads.
You can get it from his site
http://asktom.oracle.com/~tkyte/runstats.html
And here the example of its use
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:9496983726463
exec runstats_pkg.rs_start;
--Execute test1
exec runstats_pkg.rs_middle;
--Execute test2
exec runstats_pkg.rs_stop(500) /* only show those things
that differ by at least 500 */;
There you can see the comparison between two proposed solutions to tune.
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » OT: My weekly post: runstats to test fastly modification
