Re: Schedule a flush shared pool

"VC" <boston103_at_hotmail.com> wrote in message news:EN0cc.181043$1p.2148225_at_attbi_s54...
> Hello,
>
> "Tim Arnold" <timkarnold_at_comcast.net> wrote in message
> news:arqdnfGklfMo-O3dRVn-iQ_at_comcast.com...
> >
> > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
message
> > news:406d811e$0$6547$ed9e5944_at_reading.news.pipex.net...
> > > out of curiosity really why?
> > >
> > >
> > >
> >
> > We were seeing a slew of ora-4031 in the alert log.
>
> Well, the error is not the problem, rather it's a symptom of your not
> using bind variables, most likely.
>
> Instead of flushing the pool, you can:
>
> 1. Fix the application so that it used the above mentioned variables;
>
> 2. Use the band-aid of
>
> alter system set cursor_sharing=force;
>
> VC
> >
> >
>
>

the app uses bind variables.

I'm just responding to the op Received on Mon Apr 05 2004 - 07:06:03 CDT