Re: sga
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Fri, 12 Jun 2009 16:06:14 +0200
Message-ID: <cd8f74560906120706i710f2473q1d56664f881b775e_at_mail.gmail.com>
Brian,
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.
Date: Fri, 12 Jun 2009 16:06:14 +0200
Message-ID: <cd8f74560906120706i710f2473q1d56664f881b775e_at_mail.gmail.com>
Brian,
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.
br
Martin
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?
>
>
> ciao,
>
> Brian
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 12 2009 - 09:06:14 CDT