ORA-600处理一例

我是本际云服务器推荐网的小编小本本，今天为大家分享一篇关于ORA-600错误的处理案例。

ORA-600处理一例

故障处理过程

1.故障分析/处理
1.1 alertlog Fri Apr 05 22:51:36 2013 Errors in file /oracle/database/diag/rdbms/xxxdb/xxxdb2/trace/xxxdb2_j001_4223.trc (incident=72512): ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /oracle/database/diag/rdbms/xxxdb/xxxdb2/incident/incdir_72512/xxxdb2_j001_4223_i72512.trc 在4月5日22:51,连续告警两次，尔后2天内未重现。
1.2 tracefile ***2013-04-05 22:51:36.373***
SESSION ID: (837.2953) 2013-04-05 22:51:36.373 CLIENT ID:() 2013-04-05 22:51:36.373 SERVICE NAME: (SYS$USERS) 2013-04-05 22:51:36.373 MODULE NAME:(DBMS_SCHEDULER) 2013-04-05 22:51:36.373 ACTION NAME:(ORA$AT_SQ_SQL_SW_789) 2013-04-05 22:51:36.373 —–Current SQL Statement for this session (sql_id=drsnvaktx8hg8)—–/* SQL Analyze(837,1) */ select t3.org_id, decode(:1, 2, decode(t3.org_id,10017,全省,t3.org_name), 3, decode(t3.org_id,:2,全市,t3.org_name), …) d=t.channel_id and w.create_time —–PL/SQL Stack———- PL/SQL Call Stack—– object line object handle number name c000000833631a00 11816 package body SYS.DBMS_SQLTUNE_INTERNAL c00000082aa6d908 7 SYS.WRI$_ADV_SQLTUNE c000000843b3d948 587 package body SYS.PRVT_ADVISOR c000000843b3d948 2655 package body SYS.PRVT_ADVISOR c000000837c68bc0 241 package body SYS.DBMS_ADVISOR c00000082fd0a8f8 821 package body SYS.DBMS_SQLTUNE c0000008356abfa8 4 anonymous block /* SQL Analyze(837,1) */
通过tracefile中的当前SQL语句和hint可以看出，该错误与ORACLE尝试优化大型SQL相关。同时，SYS.PRVT_ADVISOR、SYS.DBMS_ADVISOR、SYS.DBMS_SQLTUNE三个程序包也证明了这一点。

错误发生时间为22:51，初步推测该错误可能与ORACLE每日自动SQL优化相关。经过MOS确认，根据ID973314.1，初步判断数据库可能遭遇bug13616375。