一．问题描述

数据库报错，看了一下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

….

二．说明：

MOS 文档：

ORA-600 [32695] [hash aggregation can't bedone] [ID 729447.1]

2.1 Applies to:

Oracle Server -Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 - Release: 10.2 to 11.1 Informationin this document applies to any platform.
***Checked for relevance on 17-Nov-2011***

2.2 Symptoms