Tag Archives: /etc/sysctl.conf

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