I want to benchmark some queries on an oracle System from a JDBC application.
However, the database seems to cache at some point in time. However, this is not intended in this case.
Is there anything like the MySQL query hint SQL_NO_CACHE.
There are Oracle query hintes
/*+ FULL(test) */ and there is even the
CACHE hint, but they concern whether the query results goes to the cache at all ...
What can I do on an Oracle System to get rid of any caching?