insert select语句报ORA-32690:Hast Table Infrastructure ran out of memory

系统环境

OS:SUNOS 5.10
DB:Oracle 10.2.0.4.0

问题现象

用户在pl/sql developer上执行insert select 语句报报ORA-32690,如图:

问题分析

根据文档(Query crash with ORA-32690 -- Bug 6471770. (文档 ID 960690.1))得知,该问题是由于Bug 6471770所致。
Bug 6471770影响的版本:10.2.0.3.0及之后的版本,并在11.2中被修复。
MOS上给出的解决办法:
Cause This seems to be Bug 6471770. - Known bug on database version 10.2.0.3. - The workaround is resolving the issue. The bug is fixed in 11.2 release. Solution: So our 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 Disable Hash group-by by setting
"_gby_hash_aggregation_enabled" to FALSE, or by using a NO_USE_HASH_AGGREGATION hint

参照文章

  • Bug 6471770  ora-32690/OERI [32695] [hash aggregation can't be done] from Hash GROUP BY
  • Query crash with ORA-32690 -- Bug 6471770. (文档 ID 960690.1)

Leave Comment