Re: buffer advisor
From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Thu, 4 Sep 2014 16:56:16 -0500
Message-ID: <CAEueRAX6v1g9ytQK4SO0hYwh9RJXjo7xyz4z8M0PB5y8-4EtLQ_at_mail.gmail.com>
Ls,
Date: Thu, 4 Sep 2014 16:56:16 -0500
Message-ID: <CAEueRAX6v1g9ytQK4SO0hYwh9RJXjo7xyz4z8M0PB5y8-4EtLQ_at_mail.gmail.com>
Ls,
I have found with very few exceptions that ASMM (SGA_TARGET) is very good at sizing the buffer cache. Have you tried this?
Seth Miller
On Sep 4, 2014 3:38 PM, "Ls Cheng" <exriscer_at_gmail.com> wrote:
> Hi all
>
> Has anyone used buffer cache advisory in 10g or 11g to size a production
> buffer cache? If so how good is the advisor recommending the cache size?
> Did the recommended cache size meet the ohysical reads reduction goal?
>
> TIA
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 04 2014 - 23:56:16 CEST