ORA-00600: internal error code, arguments: [kesqsMakeSql:sqlText]

兜兜

数据库版本：oracle 11.2.0.3.0  64bit
服务器系统：HP-UX  B.11.31 U ia64
内存：64G

Sat Mar 01 06:00:01 2014
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Errors in file /oradata1/dmpfile/diag/rdbms/pbhadb/PBHADB/trace/PBHADB_j001_2993.trc  (incident=55297):
ORA-00600: internal error code, arguments: [kesqsMakeSql:sqlText], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oradata1/dmpfile/diag/rdbms/pbhadb/PBHADB/incident/incdir_55297/PBHADB_j001_2993_i55297.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
SYS_AUTO_SQL_TUNING_TASK exiting with error "600" for execution "EXEC_34942".  See DBA_ADVISOR_EXECUTIONS for more details.
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Errors in file /oradata1/dmpfile/diag/rdbms/pbhadb/PBHADB/trace/PBHADB_j001_2993.trc  (incident=55298):
ORA-00600: internal error code, arguments: [kesqsMakeSql:sqlText], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.PRVT_ADVISOR", line 2735
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 821
ORA-06512: at line 4
Incident details in: /oradata1/dmpfile/diag/rdbms/pbhadb/PBHADB/incident/incdir_55298/PBHADB_j001_2993_i55298.trc
Sat Mar 01 06:00:09 2014
Dumping diagnostic data in directory=[cdmp_20140301060009], requested by (instance=1, osid=2993 (J001)), summary=[incident=55297].
Sat Mar 01 06:00:12 2014
Sweep [inc][55298]: completed
Sweep [inc][55297]: completed
Sweep [inc2][55297]: completed
Sat Mar 01 06:00:12 2014
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oradata1/dmpfile/diag/rdbms/pbhadb/PBHADB/trace/PBHADB_j001_2993.trc:
ORA-00600: internal error code, arguments: [kesqsMakeSql:sqlText], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.PRVT_ADVISOR", line 2735
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 821
ORA-06512: at line 4
Dumping diagnostic data in directory=[cdmp_20140301060012], requested by (instance=1, osid=2993 (J001)), summary=[incident=55298].
Sat Mar 01 06:01:12 2014
Sweep [inc2][55298]: completed
Sat Mar 01 06:01:43 2014
Thread 1 cannot allocate new log, sequence 10397
Private strand flush not complete
  Current log# 3 seq# 10396 mem# 0: /oradata1/PBHADB/redo03.log
Thread 1 advanced to log sequence 10397 (LGWR switch)
  Current log# 4 seq# 10397 mem# 0: /oradata1/PBHADB/redo04.log

Maclean Liu(刘相兵

可能是 SYS_AUTO_SQL_TUNING_TASK 在分析SQL的时候发现 某些SQL的sqlText 过长或者特殊 ，导致 SYS_AUTO_SQL_TUNING_TASK 出现ORA-600

你可以禁用SYS_AUTO_SQL_TUNING_TASK 或者考虑：

打11203最新的PSU

Maclean Liu(刘相兵

11.2.0.3.0 HP-UX B.11.31


Dump continued from file: /oradata1/dmpfile/diag/rdbms/pbhadb/PBHADB/trace/PBHADB_j001_2993.trc
ORA-00600: internal error code, arguments: [kesqsMakeSql:sqlText], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 55297 (ORA 600 [kesqsMakeSql:sqlText]) ========

*** 2014-03-01 06:00:03.567
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=5zruc4v6y32f9) -----
DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TIME ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2(30) := :job_name;  job_subname VARCHAR2(30) := :job_subname;  job_owner VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH TIME ZONE := :job_start;  job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start;  window_start TIMESTAMP WITH TIME ZONE := :window_start;  window_end TIMESTAMP WITH TIME ZONE := :window_end;  chain_id VARCHAR2(14) :=  :chainid;  credential_owner varchar2(30) := :credown;  credential_name  varchar2(30) := :crednam;  destination_owner varchar2(30) := :destown;  destination_name varchar2(30) := :destnam;  job_dest_id varchar2(14) := :jdestid;  log_id number := :log_id;  BEGIN  DECLARE
         ename VARCHAR2(30);
       BEGIN
         ename := dbms_sqltune.execute_tuning_task(
                    'SYS_AUTO_SQL_TUNING_TASK');
       END;  :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
----- PL/SQL Stack -----


stack call:
kessiWorkloadFetch => kesqsMakeSqlCb=cold_kesqsMakeSql=>报错