RE: How do you calculate Large Page settings for Oracle on AIX?

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: "kamusis@xxxxxxxxx" <kamusis@xxxxxxxxx>, oracle_l <Oracle-L@xxxxxxxxxxxxx>
  • Date: Thu, 6 Jan 2011 10:47:07 -0700

I'm not sure what the problems is - maybe you have another Oracle instance or 
something else also using large pages?  You can use svmon to get more detail 
about what is using the large pages but I would recommend just not using large 
pages anymore.  With Oracle you can use the newer and 
easier-to-manage "medium" (64K) pages as instructed and recommended by IBM here 
(and also mentioned in MOS Doc ID 968113.1):

"The new 64 KB pages are preferred over 16 MB pages, and it is recommended that 
you use them instead of 16 MB pages on systems that support both page sizes. 
This is because 64 KB pages provide most of the benefit of 16 MB pages, without 
the special tuning requirements of 16 MB pages. If the memory is not properly 
tuned for 16 MB pages, the performance can be worse."

Just beware of the bug described in MOS Doc ID 1088076.1

I used to use large pages (only or the SGA, not for .text and .data) and they 
worked fine for years, but I've been using the newer medium pages for the last 
year or so and haven't had any problems.


Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: