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@(protected)
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
-----------------------------------------------------------------