I'm running an Oracle production 11gR2 database which has around 65Gb of data, running with a 4Gb SGA & 40Mb PGA using ASMM.

Now, I have a memory increase up to 32Gb. I'm planning to increase the SGA and PGA for the database but I don't know which one I should use - AMMM or HugePages? I'm using Linux 6 (RHEL?).

  • Isn't 11 R2 coming to end of life? Go to this site and see what they have to say - it's the best Oracle install site on the web!
    – Vérace
    Apr 25, 2019 at 10:59

1 Answer 1


This is what Oracle says about it:

About HugePages

If you have a system with more than 16GB of memory running Oracle databases with a total System Global Area (SGA) larger than 8GB, you should enable the HugePages feature to improve database performance.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.