Hi April Yes you do sound like a good candidate. Things to consider. - How much memory might you ever want to use for all SGAs on the box? I'd ensure enough huge pages were allocated to cover this - most guides size based on existing SGA size which is fine until you need to expand SGA or add a new DB. - Huge Pages implies Automatic Shared Memory Management NOT Automatic Memory Management. This might be a support issue for you of course with the ERP system vendor. - Huge Pages good/ *Transparent* Huge Pages very bad.. On Tue, Jul 22, 2014 at 2:07 PM, April Sims <aprilcsims@xxxxxxxxx> wrote: > Anyone have some insight, knowledge, experience or best practices about > huge pages in Linux? > > We have new hardware: 64-bit , 32GB Memory , Linux 6, Oracle 11.2.0.3, > OS-encrypted filesystem, Native Network Encryption, 2 physical and logical > standbys in this configuration. > ERP system, lots of dedicated connections. > > We need to implement this quickly as the hardware is on site. > My understanding is that we are a good candidate for this type of > configuration and just don't want to make a major mistake along the way due > to inexperience. Lots of blog posts out there but the ones I have seen are > several years old. > > Current SGA is 8GB for a single database due to migrated to the new > hardware along with a couple of smaller databases......we do see occasional > CPU spikes on the current hardware but that is the only issue on the older > system without huge pages. > > > -- > April C. Sims > IOUG SELECT Journal Editor > 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 > -- Niall Litchfield Oracle DBA http://www.orawin.info