ORA-32690: Hash Table Infrastructure Ran out of Memory

最新推荐文章于 2025-06-07 19:24:53 发布

转载最新推荐文章于 2025-06-07 19:24:53 发布 · 698 阅读

文章标签：

#table #solaris #merge #database #patch #bugs

oracle管理专栏收录该内容

32 篇文章

订阅专栏

本文详细介绍了在使用Oracle数据库版本10.2.0.3执行大型连接语句时遇到ORA-32690错误的解决方案。推荐使用最新补丁集或11.1.0.6版本来解决此已知bug，并提供了临时工作-around方法，如禁用Hash group-by操作或在语句中使用NO_USE_HASH_AGGREGATION提示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Resolving Oracle ORA-32690: Hash Table Infrastructure ran out of memory

If you are getting ORA-32690 error when doing large join statements, you can resolve the issue with the following tips.

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