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;