| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Shared pool wait for library cache pin
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: Cherie_Machler_at_gelco.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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 <ORACLE-L_at_fatcity.com>
> <schlossnagle_at_py cc:
> thian.com> Subject: Re: Shared pool
>wait for library cache pin
> Sent by:
> root_at_fatcity.com
>
>
> 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" <ORACLE-L_at_fatcity.com>
>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: Cherie_Machler_at_gelco.com
> >
> > 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: ListGuru_at_fatcity.com (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: schlossnagle_at_pythian.com
>
>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: ListGuru_at_fatcity.com (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: Cherie_Machler_at_gelco.com
>
>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: ListGuru_at_fatcity.com (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: ARUN K C INET: arun_k_c_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Wed Jan 02 2002 - 20:35:15 CST
 |
 |