Clear oracle cache between requests

Question

I want to know the actual execution time of my request with and without different prompts. But the oracle DB caches the query after its first execution, and the second time it runs quickly. How can I clear this cache after each query execution?

Answer 1

ALTER SYSTEM FLUSH BUFFER_CACHE 

More details in the manual: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2013.htm#i2053602