I used these 2 commands to clear cache in between queries in Oracle DB especially when testing for performance:
ALTER SYSTEM FLUSH BUFFER_CACHE;
ALTER SYSTEM FLUSH SHARED_POOL;
ALTER SYSTEM FLUSH BUFFER_CACHE;
ALTER SYSTEM FLUSH SHARED_POOL;
Get updates delivered right to your inbox!