ORA-00600:[32695], [hash aggregation can't be done] 解决方法

最新推荐文章于 2024-09-25 11:06:23 发布

iteye_19543

最新推荐文章于 2024-09-25 11:06:23 发布

阅读量119

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/iteye_19543/article/details/82573051

版权

[img]http://dl2.iteye.com/upload/attachment/0095/0621/6c56c425-ead2-34dc-a5a6-b16a6e544f69.jpg[/img]
数据库报错，看了一下alertlog，主要重复如下内容：

Wed Jul 25 17:47:18 2012

Errors in file /oracle/admin/etldb/udump/etldb_ora_15674.trc:

ORA-07445: exception encountered: core dump [kghssgdmp()+273] [SIGFPE] [Integerdivide by zero] [0x40000000094555E1] [] []

ORA-07445: exception encountered: core dump[kghssgdmp()+273] [SIGFPE] [Integer divide by zero] [0x40000000094555E1] [] []

ORA-00600: internal error code, arguments:[32695], [hash aggregation can't be done], [], [], [], [], [], []

--数据库版本：

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise EditionRelease 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for HPUX: Version 10.2.0.4.0 -Production

NLSRTL Version 10.2.0.4.0 - Production

--查看/oracle/admin/etldb/udump/etldb_ora_15674.trc文件：

ORA-00600: internal error code, arguments:[32695], [hash aggregation can't be done], [], [], [], [], [], []

Current SQL statement for this session:

INSERT /*+ APPEND */ INTO DMID.TMP_MD_PAR_CON_4_M7 NOLOGGING

(

…

)

SELECT

…

FROM DMID.TMP_MD_PAR_CON_4_M8 T2

GROUP BY T2.DEAL_DATE,T2.BILLCYCL_ID

,T2.SCATT_ACCT

,T2.CONTRACT_NO

----- PL/SQL Call Stack -----

object line object

handle number name

c0000003ce3b5618 1062 procedure DMID.P_MD_PAR_CON_4_M

c000000322524998 1 anonymous block

….