Re: Schedule a flush shared pool

"Tim Arnold" <timkarnold_at_comcast.net> wrote in message news:1-ydnUJ3youkHOzd4p2dnA_at_comcast.com...
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
> news:jzecc.189165$_w.1871369_at_attbi_s53...
> >
> > "Tim Arnold" <timkarnold_at_comcast.net> wrote in message
> > news:p42dnelqTMSX1uzdRVn-hA_at_comcast.com...
> > >
> > > "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
> > >
> > >
> > Then you should have no need to flush the shared pool.
> > Jim
> >
> >
> but it works, resolves the ora-4031

Then the application is not using bind variables. Pls. post your statspack report taken during 15 mins of the time you're experiencing the problem (ORA-4031).
>
>
Received on Mon Apr 05 2004 - 16:33:50 CDT