Re: clearing the sga buffers

In article <8rkgfr$chr2_at_shark.ncr.pwgsc.gc.ca>,   "Rocr" <rolland.cright_at_pwgsc.gc.ca> wrote:
> Can't remember or find the package that allows me to clear the oracle
 sga's
> buffers. Need to do some performance testing.
>
>

Use 'ALTER SYSTEM FLUSH SHARED POOL';

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.