Re: HugePages

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_at_gmail.com> 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_at_gmail.com
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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