Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Schedule a flush shared pool
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:
alter system set cursor_sharing=force;
VC
>
>
Received on Sun Apr 04 2004 - 18:23:16 CDT