Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2101
  • Last Modified:

Enabling Large Page Support in Windows 2008 R2

How do I Enable Large Page Support in Windows 2008 R2? I will be installing Oracle 11gR2 64-bit.
0
ei00004
Asked:
ei00004
1 Solution
 
MikeOM_DBACommented:
Check out this link: Large-Page Support
or..
   
1.    Open the folder in which Debugging Tools for Windows is installed.
2.    Start the GFlags utility.
3.    In the Global Flags dialog box, click the Image File tab.
4.    In the Image: (TAB to refresh) box, type Sqlservr.exe, and then press the TAB key.
5.    Click to select the Load image using large pages if possible check box, and then click OK
0
 
ei00004Network AdministratorAuthor Commented:
I installed the Windows 7 and 2008 server R2 SDK but I do not see the GFlags utility. See attached.
Debugging-Toolkit.png
0
 
Ryan McCauleyData and Analytics ManagerCommented:
It appears you need to install Oracle first. Once that's done, the Oracle tuning guide has a few things you need to do:

http://docs.oracle.com/cd/B28359_01/win.111/b32010/tuning.htm#BCGDHBBD

Ensure your server has more physical RAM than the configured size of your SGA
Enable the "Lock Pages in Memory" security right (instructions in the tuning guide) for the service account under which the Oracle server is running
Modify the Oracle home key of the registry to specify that the instance (or all instances) should use large page support

Note that there are some additional considerations in the guide regarding whether you'd want to enable large page support, as well as some impact on the SGA, so ensure you read up before enabling it. Like any OS setting, it's not enabled by default because it's not always the best choice, but can be enabled easily if you decide it's worthwhile.

Also, note that you can install Oracle and then enable large page support later - it doesn't appear to be required that it be done first.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now