How to test tuned oracle sql and how to clear clear system/hardware buffer?
<p>I want to know the way to test right sqls before tuned and after tuned.
but once I executed the original sql, I got results too fast for tuned sql.</p>

<p>I found below...</p>

<p><a href="https://stackoverflow.com/questions/2147456/how-to-clear-all-cached-items-in-oracle">How to clear all cached items in Oracle</a></p>

<p>I did flush data buffer cache and shared pool but it still didn't work.
I guess this answer from that question is related to what I want to know more:
Keep in mind that the operating system and hardware also do caching which can skew your results.</p>

<p>Oracle's version is 11g and Server is HP-UX 11.31.</p>

<p>If the server was Linux, I could've tried clearing buffer using '/proc/sys/vm/drop_caches'.(I'm not sure it would works)</p>

<p>I'm searching quite long time for this problem. Is there anyone has this kind of problem?</p>

<p>thanks</p>