Re: Flushing Shared pool area

bulgroz_at_rocketmail.com wrote in message <70f3ce$fps$1_at_nnrp1.dejanews.com>...
>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 ?

SQL> alter system flush shared_pool;

HTH,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Mon Oct 19 1998 - 06:04:00 CDT