ORA-600 Kkqsprepforeventprocessing

告警日志报错

Errors in file /home/oracle/app/oracle/admin/s10/bdump/s10_j000_23220.trc:
ORA-00600: internal error code, arguments: [kkqsPrepForEventProcessing:1], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 13591
ORA-06512: at "SYS.DBMS_STATS", line 13937
ORA-06512: at "SYS.DBMS_STATS", line 14015
ORA-06512: at "SYS.DBMS_STATS", line 13974
ORA-06512: at "S3AUTO1.GATHERSTATISTICS", line 4
ORA-06512: at line 1

跟踪文件显示

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kkqsPrepForEventProcessing:1], [], [], [], [], [], [], []
Current SQL statement for this session:
select substrb(dump(val,16,0,32),1,120) ep, cnt from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"IS_FULFILLED" val,count(*) cnt from "S3AUTO1"."DOWNLOAD_RIGHTS" t where "IS_FULFILLED" is not null group by "IS_FULFILLED") order by val
----- PL/SQL Call Stack -----
object line object
handle number name
0x68cc9fd8 11286 package body SYS.DBMS_STATS
0x68cc9fd8 11841 package body SYS.DBMS_STATS
0x68cc9fd8 12475 package body SYS.DBMS_STATS
0x68cc9fd8 12892 package body SYS.DBMS_STATS
0x68cc9fd8 13345 package body SYS.DBMS_STATS
0x68cc9fd8 13546 package body SYS.DBMS_STATS
0x68cc9fd8 13937 package body SYS.DBMS_STATS
0x68cc9fd8 14015 package body SYS.DBMS_STATS
0x68cc9fd8 13974 package body SYS.DBMS_STATS
0x68dd0318 4 procedure S3AUTO1.GATHERSTATISTICS
0x68e36f28 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFFE94DA1D0 ? 7FFFE94DA230 ?
7FFFE94DA170 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFFE94DA1D0 ? 7FFFE94DA230 ?
7FFFE94DA170 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FFFE94DA1D0 ? 7FFFE94DA230 ?
7FFFE94DA170 ? 000000000 ?
kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ?
7FFFE94DA1D0 ? 7FFFE94DA230 ?
7FFFE94DA170 ? 000000000 ?
kgeasnmierr()+163 call kgerinv() 006217D40 ? 00D054780 ?
7FFFE94DA230 ? 7FFFE94DA170 ?
000000000 ? 000000000 ?
kkqsPrepForEventPro call kgeasnmierr() 006217D40 ? 00D054780 ?
cessing()+500 7FFFE94DA230 ? 7FFFE94DA170 ?
7FFFE94DB000 ? 7FFFE94DB010 ?
kkqsProcessNextEven call kkqsPrepForEventPro 2AF1C39495B0 ? 00D054780 ?
tLevel()+128 cessing() 7FFFE94DA230 ? 7FFFE94DA170 ?
7FFFE94DB000 ? 7FFFE94DB010 ?
kkqsNDimEventTrans( call kkqsProcessNextEven 2AF1C39493A8 ? 00D054780 ?
)+53 tLevel() 7FFFE94DA230 ? 7FFFE94DA170 ?
7FFFE94DB000 ? 7FFFE94DB010 ?
kkqsEVTransition()+ call kkqsNDimEventTrans( 2AF1C39493A8 ? 2AF1C3949B70 ?
276 ) 7FFFE94DA230 ? 7FFFE94DA170 ?
7FFFE94DB000 ? 7FFFE94DB010 ?
kkqsDoStopTransitio call kkqsEVTransition() 2AF1C39493A8 ? 2AF1C3949B70 ?
n()+190 2AF1C3949B70 ? 7FFFE94DA170 ?
7FFFE94DB000 ? 7FFFE94DB010 ?
kkqsEventWalk()+327 call kkqsDoStopTransitio 2AF1C39493A8 ? 2AF1C39492E0 ?
n() 2AF1C3949B70 ? 7FFFE94DA170 ?
7FFFE94DB000 ? 7FFFE94DB010 ?
kkqsEventWalk()+558 call kkqsEventWalk() 2AF1C39493A8 ? 2AF1C39492E0 ?
2AF1C3949148 ? 000000000 ?
7FFFE94DB000 ? 7FFFE94DB010 ?
...

这是一个BUG, 还没有linux版本补丁, 解决办法是:

alter system set "_mmv_query_rewrite_enabled"=FALSE;

外部链接:
Ora-00600: Internal Error Code, Arguments: [Kkqsprepforeventprocessing:1], [],
Bug 6001239 - OERI[kkqsPrepForEventProcessing:1] during query rewrite
XF11.1GSTAT - TRC - KKQSPREPFOREVENTPROCESSING



-fin-