testing sql and perf

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_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

  ---