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


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

….