Have u tried disabling the timed_statistics=false in 8.1.5 there is a bug I am not sure. But try this out, When you are saying u are seeing very high version_count,then I have a feeling it pointing to that bug. Try disabling the timed_statistics and see.
>From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Shared pool wait for library cache pin >Date: Wed, 02 Jan 2002 13:35:20 -0800 > > >Yes, there are a handful with more than 400. >I'm not sure what high is? > >Cherie > > > > "George > Schlossnagle" To: Multiple recipients of >list ORACLE-L <[EMAIL PROTECTED]> > <schlossnagle@py cc: > thian.com> Subject: Re: Shared pool >wait for library cache pin > Sent by: > [EMAIL PROTECTED] > > > 01/02/02 02:41 > PM > Please respond > to ORACLE-L > > > > > > >Do any of your queries have a high version_count (visible through >v$sqlarea)? > >George > >----- Original Message ----- >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Wednesday, January 02, 2002 3:20 PM > > > > > > We are seeing a lot of shared pool waits (for libary cache pin) on > > our 8.1.5 web-based application. We are seeing this via Precise/Indepth > > SQL monitoring tool. > > > > I haven't been able to find much documentation on shared pool waits or > > library cache pins. > > > > Can anyone tell me what might be causing this problem? > > > > Thanks, > > > > Cherie > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: George Schlossnagle > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
