My Oracle Support Banner

应用了补丁 20635353 之后仍发生PRTMV 分配过多内存导致 ORA-04031的问题 (Doc ID 2577523.1)

Last updated on AUGUST 21, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.1.0.2 和更高版本
本文档所含信息适用于所有平台

症状

ORA-04031: unable to allocate 4072 bytes of shared memory ("shared pool","SITE_DEF","pacdHds_kkpaco","kksgaAlloc: firstN") , 伴随 PRTMV 分配过高即使应用了补丁 20635353:

TOP 20 MEMORY USES ACROSS SGA HEAP 1 - 7
----------------------------------------------
"PRTMV " 30 GB 60%

更改

 

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


文档内容
症状
更改
原因
解决方案
参考

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.