Internal Error Code Arguments 32695
internal error code, arguments: [32695], [hash aggregation can't be done], [], [], [], [], [], [] Look for this error at MOS, I can see it is a bug. (if you have access to Support refer note 729447.1). It recommend upgrade until fixed version or apply two workaround, putting disable for all database or our session with; alter system set "_gby_hash_aggregation_enabled" = false; alter session set "_gby_hash_aggregation_enabled" = false; Other option http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=40806&DestinationA=RSS is patch statement (or create an outline) using the next hint. /*+ NO_USE_HASH_AGGREGATION */ HTH - Antonio NAVARRO Share this:TwitterFacebookLike this:Like Loading... Related This entry was posted in General, ORA-, ORACLE. Bookmark the permalink. Post navigation Subscription For Node Down Event StillPending How To Know Parameters With Which a Statement IsExecuted Leave a https://sql1.wordpress.com/2015/04/14/ora-00600-internal-error-code-arguments-32695/ Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. Search for: Recent Posts ORA-19554 And ORA-27211 Erros ExecutingBackup Archive Full Don't Report Error On12c ORA-19625 ORA-27037 Errors Using Incrementally UpdatingBackups Oracle Ports Scanner (JavaVersion) User SYS Is Immune To The ComplexityFunction Archives October 2016 September 2016 August 2016 July 2016 June 2016 May 2016 April 2016 March 2016 February 2016 January 2016 December 2015 November 2015 October 2015 September 2015 August 2015 July 2015 June 2015 May 2015 April 2015 March 2015 February 2015 January 2015 December 2014 November 2014 October 2014 Septem
【知识库】深度学习知识图谱上线啦 ORA-00600:[32695], [hash aggregation can't be done] 解决方法 http://blog.csdn.net/tianlesoftware/article/details/7790839 标签: parameterspatchexceptionoraclesqlsession 2012-07-26 20:07 6634人阅读 评论(0) 收藏 举报 本文章已收录于: 分类: Oracle Troubleshooting(193) 作者同类文章X 版权声明:本文为博主原创文章,未经博主允许不得转载。 一.问题描述数据库报错,看了一下alertlog,主要重复如下内容:Wed Jul 25 17:47:18 2012Errors 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 internal error 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 - 64biPL/SQL Release 10.2.0.4.0 - internal error code ProductionCORE10.2.0.4.0 ProductionTNS for HPUX: Version 10.2.0.4.0 -ProductionNLSRTL 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 T2GROUP BY T2.DEAL_DATE,T2.BILLCYCL_ID ,T2.SCATT_ACCT ,T2.CONTRACT_NO ----- PL/SQL Call Stack -----object line objecthandle number namec0000003ce3b5618 1062procedure DMID.P_MD_PAR_CON_4_Mc000000322524998 1anonymous 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 SymptomsWhen running astatement that involves a GROUP BY operation, the following error is raised:ORA-00600:internal error code