Re: Flushing Shared pool area

Also, don't forget about dbms_shared_pool.keep()!

Greg Parsons wrote:

> 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 - 22:03:35 CDT