OT: My weekly post: runstats to test fastly modification

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 5 Apr 2004 18:27:07 -0400
Message-ID: <003201c41b5d$27cea8a0$2501a8c0@dazasoftware.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Apr 05 2004 - 17:27:33 CDT