Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> OT: My weekly post: runstats to test fastly modification

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US