Re: anyway to flush the db_buffer_cache?

Originally posted by Ryan
> Im doing some tuning now and its hard to establish benchmarks
> if all the
> blocks are in memory. So for tuning purposes only Id like to flush
> them out
> to test different methods.
>
> Im not a good enough tuner to simply analyze a plan and no for
> certain what
> to do.

1. Nobody can tell from an explain plan whether it is good or not.
2. From Oracle 9 on you can flush the buffer cache with the following command: alter session set events 'immediate trace name flush_cache';

It will flush all pools but will not flush pinned buffers. The latter should not be a concern if yours is the only active session in the system.

Credit to Julian Dyke of BMC.

--
Posted via http://dbforums.com