Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Flushing Shared pool area
alter system flush shared_pool
Barry Jones
Logica UK Ltd.
bulgroz_at_rocketmail.com wrote in article
<70f3ce$fps$1_at_nnrp1.dejanews.com>...
> Hi,
>
> I would like to find a way to flush the Share Pool Area of any query that
> might be sitting in ther in order to perform some repetitives query tests
> over differrent time of day.
>
> Besides shutting down the instance, any other way ?
>
> Thanks.
>
> _______________________________________________________________________
> Bruno Cipelletti (04 76 14 94 37)
> Hewlett Packard
> PSDE / MDIS : MISTRAL - ALIZES Projects
>
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
Received on Mon Oct 19 1998 - 06:12:28 CDT