Re: library cache get hit ratio
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Brian.Zelli@xxxxxxxxxxxxxxx
- Date: Thu, 2 Dec 2010 13:57:57 -0600
Sounds like you need to look at the usage of bind variables. If your
developers are using a tool and dont know whats under the hood, you may need
to look at the cursor_sharing settings. What Oracle version are you using?
On Thu, Dec 2, 2010 at 1:45 PM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx>wrote:
> I am seeing my lib cache get hit ratio at 60-70%. What I read says it
> should be above 90%. It says if it is low to increase shared pool size. I
> doubled it and still see no difference.
> Anything else to change?
>
> It also says to improve the efficiency of the app code but the developers
> are using a tool that creates the app and are clueless as to what's under
> the hood.
>
>
> ciao,
>
> Brian
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
