Last updated on July 17th, 2015 at 06:05 pm
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
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 appropiately
alter system set SGA_TARGET=0 scope=spfile;
alter system set DB_CACHE_SIZE=XXG scope=spfile;
alter system set SHARED_POOL_SIZE=XXG scope=spfile;
alter system set SHARED_POOL_RESERVE_SIZE=XG scope=spfile;
Once both the changes are done,Bounce the database to have those changes in effect
sqlplus / as sysdba
Verify the parameter in the database.
Also check the large pages uses on the OS side