Date: Fri, 12 Jun 2009 08:04:58 -0500
Well, adding memory is an option. You should also look at your code. If you are not using bind variables, that can also cause the problem, and it is almost impossible to fix that problem just by adding memory.
On Fri, Jun 12, 2009 at 8:01 AM, Zelli, Brian <Brian.Zelli_at_roswellpark.org>wrote:
> Ok, so I have my sga tuned by the advisor in 10g but I have a library
> cache hit ratio constantly below the recommended threshold of 90%. How the
> heck do I tune it? Do I just increase the sga_target?
> 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.' -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 12 2009 - 08:04:58 CDT