1.两个节点都修改limits.conf
–添加参数
* hard memlock unlimited
* soft memlock unlimited
2.变更时间.登录节点2
–查看当前节点数据库有没有DML操作
#(ORACLE)
SQL > set line 200 pages 1000
col event for a30
col program for a25
col username for a10
col exec_time for 9999999999
col sql_id for a15
col machine for a16
col ssid for a13
col state for a20
col status for a10
select inst_id||':'||sid||','||serial# ssid,username,sql_id,sql_exec_id,event,substr(program,1,25) program,state,last_call_et exec_time,status ,machine
from gv$session
where wait_class<>'Idle' and username is not null
order by last_call_et;
3.检查后关闭数据库
#(ORACLE)
SQL > shutdown immediate
4.重新登录回Oracle用户再重启数据库
–查看当前 locked memory值
ulimit -a
5.重启数据库
#(ORACLE)
SQL > startup
6.查看大页使用情况
cat /proc/meminfo
7.节点1于节点2相同操作