昨天晚上数据库突然报出600错误,下面是截取的一段

----------------------------------------------------------------------

*** ACTION NAME:() 2012-03-05 20:54:25.674

*** MODULE NAME:(SQL*Plus) 2012-03-05 20:54:25.674

*** SERVICE NAME:(SYS$USERS) 2012-03-05 20:54:25.674

*** SESSION ID:(1015.55232) 2012-03-05 20:54:25.674

*** 2012-03-05 20:54:25.674

ksedmp: internal or fatal error

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

Current SQL statement for this session:

select min(minbkt),maxbkt,substrb(dump(min(val),16,0,32),1,120) minval,substrb(dump(max(val),16,0,32),1,120) maxval,

sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep

from (select val,min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from

(select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */substrb("BANK_PASSWD",1,32) val,

ntile(254) over (order by nlssort(substrb("BANK_PASSWD",1,32),'NLS_SORT = binary')) bkt from "GCUSER"."USERS" t where substrb("BANK_PASSWD",1,32) is not null)

group by val) group by maxbkt order by maxbkt

----- PL/SQL Call Stack -----

object line object

handle number name

0xa2fa9c9f0 11543 package body SYS.DBMS_STATS

0xa2fa9c9f0 11849 package body SYS.DBMS_STATS

0xa2fa9c9f0 12475 package body SYS.DBMS_STATS

0xa2fa9c9f0 12892 package body SYS.DBMS_STATS

0xa2fa9c9f0 13345 package body SYS.DBMS_STATS

0xa2fa9c9f0 13546 package body SYS.DBMS_STATS

0xa2fa9c9f0 13942 package body SYS.DBMS_STATS

0xa2fa9c9f0 14015 package body SYS.DBMS_STATS

0xa2fa9c9f0 13974 package body SYS.DBMS_STATS

------------------------------------------------------------------------------------

这条sql应该是统计直方图时执行的, 由dbms_stat包发出, 那应该就是在收集统计信息时出的问题了.

经过网上查询,发现是由hash group by 这个10.2的特性导致的一个oracle的bug.

参考文章:http://space.itpub.net/231499/viewspace-63856

解决方法 :禁用hash group by

alter system set "_gby_hash_aggregation_enabled"=false;

alter session set "_gby_hash_aggregation_enabled"=false;

[@more@]

ITPub博客

ora-600[32695]错误