ORA-32690: 散列表基础结构内存不足

ORA-32690: 散列表基础结构内存不足


[oracle@sdw0 ~]$ oerr ora 32690
32690, 00000, "Hash Table Infrastructure ran out of memory"
// *Cause: Not enough memory.
// *Action: Increase memory.

This is a known bug on database version 10.2.0.3. The bug is fixed in 11.2 release.

Recommended solution always to be on the latest patchset or even 11.1.0.6 where there is one off backport for several platforms .

The bug also has a one off on top of 10.2.0.4, if you are not able to be on top of 10.2.0.4 for the time being, so our option now is to resolve the issue on top of 10.2.0.3

No one off on top of 10.2.0.3 for Solaris platform however the good news that there is a merge Patch 6907160 MERGE LABEL REQUEST ON TOP OF 10.2.0.3 FOR BUGS 6471770 6471515, available to Solaris platform.

There are also the available workarounds
1. Disable Hash group-by by setting “_gby_hash_aggregation_enabled” to FALSE in init.ora
2. Use a NO_USE_HASH_AGGREGATION hint in your statements


原因分析:


解决方法:

1.增加PGA的pga_aggregate_target的大小。

2.Disable HASH GROUP BY operations bysetting the parameter _gby_hash_aggregation_enabled to FALSE:

   SQL> alter session set"_gby_hash_aggregation_enabled" = false;

    or

   SQL> alter systemset "_gby_hash_aggregation_enabled" = falsescope=spfile; 

   A hard parse tothe statement needs to be performed, preferably to flush the Shared Pool aftersetting this workaround and then re-run the statement.

   --要使修改生效,需要执行一次硬解析,所以可以选择flush share pool,然后执行SQL

3.不使用hash join:select /*+ NO_USE_HASH_AGGREGATION*/.....
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值