Tag Archives: /etc/sysctl.conf

Reconfigure OS Parameters After Linux Server Memory Upgrade

One of the Oracle database server ‘s memory is to be upgraded from 48GB to 72GB, so some parameters should be adjusted to take advantage of the newly added memory. 1)  Change ‘memlock’ parameter in /etc/security/limits.conf to 70G, which is … Continue reading

Posted in Configuration, Linux | Tagged , , , , , , , , | Leave a comment

High Swap Usage On Oracle Database Server

Situation: When investigating one client’s Oracle database server high swap memory usage, we find the swap space usage is constantly very high on this Linux server, which causes Oracle database a big performance issue. OS: RHEL 7.3 DB: Oracle 12.2.0.1 … Continue reading

Posted in Linux, Performance Tunning | Tagged , , , , , , , , , , , , , , | Leave a comment

How to Configure HugePages for Oracle Database on Linux

a) Setting up  memlock in /etc/security/limits.conf. Make this parameter slightly smaller than available physical memory ( 512G ). oracle soft memlock 475830802 oracle hard memlock 475830802 b) Check memlock setting is effective by logging as oracle user. $ ulimit -l 475830802 … Continue reading

Posted in Configuration, GI and RAC | Tagged , , , , , , , | Leave a comment