Re: anyway to flush the db_buffer_cache?

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in news:3EB470CC.7F87_at_yahoo.com:

> A full scan will not necessaily clear the cache because Oracle will do
> its best not to allow full scans to do so.
>
> Off-then-on-lining a tablespace will clear the buffers.
>
> hth
> connor

Will it clear them or simply checkpoint them? It was my understanding that checkpointing does not clear a block from the cache but simply ensures that dirty blocks are written to disk? Received on Tue May 06 2003 - 08:21:41 CDT