Enable SGA big page (LARGEPAGE) in ORACLE on AIX)

Source: Internet
Author: User
The following is the configuration and monitoring of the SGA big page on the AIX platform. 1. The page size supported by aix. AIX supports four types of page sizes, however, not every hardware platform supports four types at the same time. You can use the following command to view

The following is the configuration and monitoring of the SGA big page on the AIX platform. 1. The page size supported by aix. AIX supports four types of page sizes, however, not every hardware platform supports four types at the same time. You can use the following command to view

The following is the configuration and monitoring of the SGA big page on the AIX platform.

1. Page size supported by aix

AIX supports four types of page sizes, but not every hardware platform supports four types at the same time. You can use the following command to view

2. Prerequisites for enabling large pages in server space and ORACLE

ORACLE has the following three types of memory that support big pages SGA,. DATA,. TEXT. Here we only introduce the SGA and Hong Kong virtual hosts, because under normal circumstances we only configure SGA.

If ORACLE wants to enable a large page, the ORACLE user must have the CAP_BYPASS_RAC_VMM and CAP_PROPAGATE attributes. If it is in the RAC environment, ROOT, GRID (11G) you must also use the following command to view and modify the CAP_BYPASS_RAC_VMM and CAP_PROPAGATE attributes.

3. AIX is equivalent to a large page parameter.

Lgpg_regions controls the number of large pages lgpg_size controls the page size, Hong Kong Server rental, use the following command to view and modify

4. Calculate the number of lgpg_regions

  • 5. Modify lru_file_repage.

  • Change lru_file_repage to 0. The default value is 1.
  • 6. Check whether large page is used in oracle sga.

    Run the svmon command to view

    The host that logs on here does not support large page, so I took an online image.

    7. Use vmstat to view large page usage

    This article is from the "seriously lose" blog. Please keep this source

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.