Re: HugePages

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: April Sims <aprilcsims@xxxxxxxxx>
  • Date: Tue, 22 Jul 2014 14:29:53 +0100

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

Other related posts: