Re: Flushing Shared pool area

From: Greg Parsons <parsons_at_inmet.com>
Date: Tue, 20 Oct 1998 12:28:18 GMT
Message-ID: <362C81E1.496F3F47@inmet.com>

Hi,

Others have suggested the command. Keep in mind, it'll only flush those items which are not apart of a current query or process, so 1 - you really won't have to bring it down but 2 - if you're running multiple sessions you could, potentially, not flush the pcode from your latest rev.

HTH,
Greg

bulgroz_at_rocketmail.com wrote:

> 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 Tue Oct 20 1998 - 07:28:18 CDT