Re: sga

From: Martin Berger <>
Date: Fri, 12 Jun 2009 16:06:14 +0200
Message-ID: <>

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 <>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

Received on Fri Jun 12 2009 - 09:06:14 CDT

Original text of this message