在Oracle 12.1.0.2上进行大量交换 [英] Heavy swapping on oracle 12.1.0.2

问题描述

我遇到以下错误.我的数据库版本是"Oracle Database 12c企业版12.1.0.2.0版-64位生产"，我已经通过了Doc ID 1919850.1.我想知道是否有避免交换的方法.

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.

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

推荐答案

我们在该服务器上配置了可解决此问题的巨大页面.

We have configured hugepage on that server which solves the issue.

这篇关于在Oracle 12.1.0.2上进行大量交换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！