testing sql and perf

  • From: "David Green" <thump@xxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 3 May 2004 10:47:02 -0500 (CDT)

How do you all test sql and code adjustment changes taking into account
caching of data from previous code related runs as well as other users in
database having data in cache?

If I run a query the first time I get tkproff output vastly different from
subsequent runs.  I can't see it being practical to restart the database
between each run.

- David
----------------------------------------------------------------
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: