Flush the Data Buffer Cache

In Oracle 9i and beyond you can flush the buffer cache with this command:

alter session set events ‘immediate trace name flush_cache’;


In Oracle 10g and beyond, this command will flush the buffer cache:

alter system flush buffer_cache;