• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Enabling Large Pages on Oracle Database running on IBM AIX

Enabling Large Pages on Oracle Database running on IBM AIX

January 2, 2021 by techgoeasy Leave a Comment

What is Large Pages and How it benefits Oracle database on IBM AIX
 

AIX support two virtual page sizes: 4 kilobytes (standard page) and 16 megabytes (large page). When using large pages to map virtual memory, there are fewer page boundaries, which improve the performance of prefetching.

Both online transaction processing (OLTP) and data warehouse environments can benefit from using large pages.

For applications such as Oracle, which typically uses a large amount of virtual memory, using large page memory will generally result in improved performance. There are three types of memory with which Oracle can use large pages: shared memory (SGA), process data (.data), and the instruction text (.text).

AIX changes Required
 

1) Configure the AIX large page pool by calculating the number of large pages required for the SGA:

num_of_large_pages = INT((total_SGA_size-1)/16MB)+1

As root:

vmo -p -o lgpg_regions=num_of_large_pages -o lgpg_size=16777216
vmo -o lru_file_repage=0

2) Enable the Oracle UNIX account to access large memory pages.
As root, check the current settings for the user account:

lsuser -a capabilities oracle

Add the ‘CAP_BYPASS_RAC_VMM’ and ‘CAP_PROPAGATE’ if needed:

chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

Database Changes Required

1) Set ‘lock_sga=true’ so that you get a contiguous piece of memory that can’t be taken by another process on the box.

alter system set LOCK_SGA=true scope=spfile

2) Set ‘sga_target=0’ so that automatic memory management is turned off.We dont need to dynamically resize memory settings when a large SGA is in use

Set the db_cache_size,shared_pool _size and shared_pool_reserved_size appropriately

alter system set SGA_TARGET=0 scope=spfile;
alter system set DB_CACHE_SIZE=10G scope=spfile;
alter system set SHARED_POOL_SIZE=1G scope=spfile;
alter system set SHARED_POOL_RESERVE_SIZE=.1G scope=spfile;

Once both the changes are done,Bounce the database to have those changes in effect

sqlplus / as sysdba
shutdown immediate
startup

Verify the parameter in the oracle database.

Sqlplus / as sysdba
show parameter lock_sga SGA_TARGET DB_CACHE_SIZE SHARED_POOL_SIZE SHARED_POOL_RESERVE_SIZE

Also check the large pages uses on the OS side

svmon –G

Related Articles

Oracle Performance tuning Glossary

How to create spfile from pfile

How to use Putty for SSH

Filed Under: Oracle, Oracle Database Tagged With: large page

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • how to find file based on size in linux
  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us