ORA-00600: [32695], [hash aggregation can't be done] Solution

I. Problem Description

Database Error. Read alertlog, which repeats the following content:

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], [], [], [], [], [], [], [], []

 

 

--Database Version:

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

 

 

--View/Oracle/admin/etldb/udump/etldb_ora_15674.trcFile:

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

....

1 2 Next Page