Re: Flush Block Buffer Cache?

In article <Bwzu7.539$Wz5.1664_at_nsw.nnrp.telstra.net>, sweidanz_at_yahoo.com says...
>
>folks,
>
>Is there a way to flush out the block buffer cache?
>I know there is a way to flush out the shared pool using alter system
>flush shared_pool;
>
>any idea,
>thanks
>ZS

if you take a tablespace offline, it'll flush the blocks related to that tablespace.

In 9i, you could dynamically "shrink" the buffer cache and then grow it back again to achieve a similar effect.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp