Re: anyway to flush the db_buffer_cache?

Howard J. Rogers wrote:
>
> The only way to *clear* the cache so that data can't be found in it at all
> is to bounce the instance.

"ONLY" way?
Never say, "Never".

IIRC, in V9.2 there is a DBMS_???? package call which does flush the DB_BLOCK_BUFFERS. It was discussed at the HOTSOS symposium in Dallas in February 2003.

With old age, the memory is the 2nd facility to fail, and I don't remember the which is the first. ;-) Received on Tue May 06 2003 - 18:53:33 CDT