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