ORA-00600: internal error code, arguments: [32695], [hash aggregation can't be done], [], [], [], [], [], []
原因:oracle 10gR2引进了hash group by优化方式,它使group by时使用hash的方式进行分组,避免了排序操作,但有Bug 6471770
解决方法:
1). set _gby_hash_aggregation_enabled = false e.g.:
alter system set "_gby_hash_aggregation_enabled"=false;
alter session set "_gby_hash_aggregation_enabled"=false
2).加hint /*+ no_use_hash_aggregation */
阅读(1916) | 评论(0) | 转发(0) |