Re: clearing the sga buffers

From: Rocr <rolland.cright_at_pwgsc.gc.ca>
Date: Fri, 13 Oct 2000 10:33:20 -0400
Message-ID: <8s76fh$nm07@shark.ncr.pwgsc.gc.ca>

Thanks, this worked well.

Cheers everyone...
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:970911642.26929.2.nnrp-04.9e984b29_at_news.demon.co.uk...
>
> 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 Fri Oct 13 2000 - 09:33:20 CDT