Hi April, 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@xxxxxxxxx> 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@xxxxxxxxx >