Re: huge pages, ASMM and SGA sizing

Is V$SGA_TARGET_ADVICE being populated?

From what I recall either manual allocation or ASMM are your only options, because AMM is not supported with HugePages.

I have some queries that I've used for tuning SGAs, I have to run now but I'll get them for you later.

-Justin

On Wed, Jul 23, 2014 at 7:56 AM, April Sims <aprilcsims_at_gmail.com> wrote:

> Thanks to everyone with the Huge pages advice....we now have it enabled.
>
> I am now getting pressure from all sides to increase the SGA "because we
> have plenty of memory now" with huge pages. Triple the current SGA
> size....what are the ramifications of doing this? In 10G there were lots
> of easy ways to check buffer/pool sizes with hit ratios.
>
> Does anyone have some advice? I need solid evidence to back up what I
> say....just pointing to the ADDM report isn't what they want. We don't own
> Database Replay.
>
>
> I currently have the SGA allocated manually....I have not turned on ASMM
> yet (but it is on the table) and don't plan on using AMM due to known
> issues with huge pages.
>
> Currently on 11.2.0.3 with a planned upgrade to 12.1.0.2 within the year.
>
> thanks,
>
> --
> April C. Sims
> http://aprilcsims.wordpress.com
> Twitter, LinkedIn
> Oracle Database 11g – Underground Advice for Database Administrators
>
> <http://www.amazon.com/Oracle-Database-Underground-Advice-Administrators/dp/1849680000/ref=sr_1_1?ie=UTF8&s=books&qid=1272289339&sr=8-1#noop>
> https://www.packtpub.com/oracle-11g-database-implementations-guide/book
> OCP 8i, 9i, 10g, 11g DBA
> Southern Utah University
> aprilcsims_at_gmail.com
>

--
http://www.freelists.org/webpage/oracle-l