Flush the buffer cache in Oracle
June 26th, 2007
Flush the buffer cache in [tag]Oracle[/tag]. This invalidates also the read cache, so the query performance results provides from the physical reads time.
alter system flush buffer_cache;
This command is not available prior to 10g. It flushes the buffer cache in the SGA.
9i had an undocumented command to flush the buffer cache:
alter session set events = 'immediate trace name flush_cache';