oracle占用swap如何清理,Swap空间利用率不释放

某个数据库系统，Swap空间一直利用率很高，不能释放。

交代一下环境：

[oracle@salesdb admin]$ more /etc/redhat-release

Red Hat Enterprise Linux Server release 7.2 (Maipo)

[oracle@salesdb admin]$ sqlplus -v

SQL*Plus: Release 12.1.0.2.0 Production

[oracle@salesdb admin]$ more /etc/sysctl.conf

kernel.shmmax = 395136991232

kernel.shmall = 96468992

kernel.shmmni = 4096

kernel.sem = 5010 641280 5010 128

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

net.core.rmem_default=8388608

net.core.rmem_max=16777216

net.core.wmem_default=8388608

net.core.wmem_max=16777216

fs.aio-max-nr=1048576

vm.swappiness = 0                           ###############这个参数###########

kernel.sysrq = 0

kernel.core_uses_pid = 1

kernel.threads-max = 65535

kernel.msgmni = 16384

kernel.msgmnb = 65535

kernel.msgmax = 65535

vm.nr_hugepages = 77572

其中设定了swappiness=0，理解的是为0就是优先使用物理内存，我们看看系统里识别到的到底是多少

调取了系统history，未找到sysctl -p或者reboot步骤，遂决定停库让其参数生效，还有vm.nr_hugepages参数也有oracle提供的脚本进行建议设定；

1，非7.2内核版本可参考；

#!/bin/bash

#

# hugepages_settings.sh

#

# Linux bash script to compute values for the

# recommended HugePages/HugeTLB configuration

#

# Note: This script does calculation for all shared memory

# se