设为首页 加入收藏

TOP

ORA-04031: Unable To Allocate 32 Bytes Of Shared Memory(三)
2017-10-13 09:44:29 】 浏览:9882
Tags:ORA-04031: Unable Allocate Bytes Shared Memory
sor", and "execution". By default these durations are separate from each other.

 

The disable durations, you have to set the underscore parameter:

"_enable_shared_pool_durations = false"

This is recommended by development for all similar issues.

 

The main advantage of "_enable_shared_pool_durations = false" is that all the durations are combined into one pool and so a duration will not run out while another duration has free memory. 

This issue will be fixed in 12c version due to architectural changes which will allow less need of durations for subpools.

 

Note: 

Please note that unpublished Enhancement Request Bug 8857940 - NEED COMMON DURATIONS FOR UNSHRINKABLE POOLS 8857940, fixed starting with 12.1.0.1, addresses the durations issue as well. With the fix for Bug 8857940 in place, Oracle permits to group the shared pool durations in 2 groups to allow better shareability of the memory and avoid the ORA-4031 errors. 

Another possible solution is to apply Patch 8857940 if it is available for your platform and version.

 

REFERENCES

BUG:19236833 - EXADATA: ORA-04031: UNABLE TO ALLOCATE 32 BYTES OF SHARED MEMORY "SQLA" "TMP"

NOTE:411.1 - ADR Different Methods to Create IPS Package

BUG:17789414 - SUPERCLUSTER: ORA-4031 ERRORS OCCURING WEEKLY CAUSING INSTANCE CRASHES

BUG:20447919 - ORA-4031: UNABLE TO ALLOCATE 32 BYTES

 

首页 上一页 1 2 3 下一页 尾页 3/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇HBase 磁盘爆满 无法启动 下一篇7个实战项目带你应用神经网络

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目