This doesn't work with version 8.1, although it
would with 7. The offering from Conor about
putting tablespaces offline temporarily will
do the trick though, but you have to know
which tablespaces to bounce by looking at
X$BH
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Yong Huang wrote in message <8rlamb$5h1$1_at_localhost.localdomain>...
>That clears shared pool, not the other two parts of SGA. I believe the
>poster wants to clear buffer cache. Other than bounce the database, I can't
>think of any way. Maybe run select * from all large tables or v$ views to
>occupy buffer cache so other stuff is squeazed out.
>
>Yong Huang
>yhuang_at_indigopool.com
>
Received on Sat Oct 07 2000 - 04:06:37 CDT
