Date: Fri, 12 Jun 2009 16:06:14 +0200
do you still face a Problem or just want to 'tune' for the sake of a ratio? If still anything is slow (= below requsted response and/or throughput), check for the wait event which causes max time (as Mathias suggested). Otherways: forget the ratio and just be happy.
even with huge SQLs, modern CPUs are often fast enough for a lot of Parsing
(and often IO is your bottleneck...)
but this are just ideas without any knowledge of the system.
On Fri, Jun 12, 2009 at 15:01, 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?