oracle 12.1.0.2 上的大量交换
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/36855804/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Heavy swapping on oracle 12.1.0.2
提问by Shariar Imtiaz
I am getting following error. My DB version is "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production" and i have already gone through Doc ID 1919850.1. I want to know if there is any way to avoid swapping.
我收到以下错误。我的数据库版本是“Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production”，我已经阅读了 Doc ID 1919850.1。我想知道是否有任何方法可以避免交换。
WARNING: Heavy swapping observed on system in last 5 mins. pct of
memory swapped in [1.80%] pct of memory swapped out [3.26%]. Please
make sure there is no memory pressure and the SGA and PGA are
configured correctly. Look at DBRM trace file for more details. Errors
in file /oradb/oracle/diag/rdbms/PROD/PROD/trace/PROD_dbrm_7340532.trc
(incident=16875): ORA-00700: soft internal error, arguments:
[kskvmstatact: excessive swapping observed], [], [], [], [], [], [],
[], [], [], [], [] Incident details in:
/oradb/oracle/diag/rdbms/PROD/PROD/incident/incdir_16875/PROD_dbrm_7340532_i16875.trc
Tue Jun 16 09:41:47 2015 Dumping diagnostic data in
directory=[cdmp_20150616094147], requested by (instance=1,
osid=20120017 (DBRM)), summary=[incident=16875]. Tue Jun 16 09:41:50
2015 Sweep [inc][16875]: completed Sweep [inc2][16875]: completed
回答by Shariar Imtiaz
We have configured hugepage on that server which solves the issue.
我们已经在该服务器上配置了大页面来解决这个问题。
回答by andjelko miovcic
In order to be able to increase SGA and PGA you need to have memory, ... If you set hugepage, the map table (table that managed by processes) will be consume less memory automatically we have more memory to increase PGA & SGA
为了能够增加SGA和PGA你需要有内存，...如果你设置hugepage，映射表（由进程管理的表）将自动消耗更少的内存我们有更多的内存来增加PGA和SGA
回答by Derek J.
It's very clearly that memory lack, if server memory has enough free space, try to increase SGA (and PGA) max size, if server has less memory, consider add one or increase /proc/sys/vm/swappiness(only necessary).
很明显内存不足，如果服务器内存有足够的空闲空间，尝试增加SGA（和PGA）max size，如果服务器内存较少，考虑增加一个或增加/proc/sys/vm/swappiness（只需要）。
