Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.moat.net!news.glorb.com!wn52feed!worldnet.att.net!attbi_s54.POSTED!not-for-mail
From: "VC" <boston103@hotmail.com>
Newsgroups: comp.databases.oracle.misc
References: <nSebc.34699$zm5.14577@nntpserver.swip.net> <0_adnTYQ-t564_DdRVn-jA@comcast.com> <406d811e$0$6547$ed9e5944@reading.news.pipex.net> <arqdnfGklfMo-O3dRVn-iQ@comcast.com>
Subject: Re: Schedule a flush shared pool
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <EN0cc.181043$1p.2148225@attbi_s54>
NNTP-Posting-Host: 24.34.72.170
X-Complaints-To: abuse@comcast.net
X-Trace: attbi_s54 1081120996 24.34.72.170 (Sun, 04 Apr 2004 23:23:16 GMT)
NNTP-Posting-Date: Sun, 04 Apr 2004 23:23:16 GMT
Organization: Comcast Online
Date: Sun, 04 Apr 2004 23:23:16 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:137406

Hello,

"Tim Arnold" <timkarnold@comcast.net> wrote in message
news:arqdnfGklfMo-O3dRVn-iQ@comcast.com...
>
> "Niall Litchfield" <n-litchfield@audit-commission.gov.uk> wrote in message
> news:406d811e$0$6547$ed9e5944@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
>
>