Re: anyway to flush the db_buffer_cache?

True enough. So will making it read-only. But flushing blocks to disk doesn't mean the data won't be in the cache, merely that those blocks/buffers will be over-writeable in the event of you needing to with another bulky select.

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

Regards
HJR "srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0305052044.456a6a60_at_posting.google.com...
> I read somewhere, someone saying (i think Jonathan ?) that taking a
> tablespace offline will flush all the blocks from that tablespace.
> regards
> Srivenu
Received on Tue May 06 2003 - 11:37:40 CDT