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

执行某存储过程出现以下错误信息:

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

此存储过程操作大量的数据,网络上的这篇文章解释了这个故障:

  http://space6212.itpub.net/post/12157/399059

 

根据以上博文内容,我在自己的存储过程起始位置添加以下内容后,问题解决:

EXECUTE IMMEDIATE 'alter session set "_gby_hash_aggregation_enabled" = false';

 

---END;

posted @ 2012-02-10 17:54  Mr.chenz  阅读(650)  评论(0编辑  收藏  举报