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: , [], [], [], [], [], [], [], [], [], [], []
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: , [], [], [], [], [], [], [], [], [], [], []
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=, requested by (instance=1, osid=2993 (J001)), summary=.
Sat Mar 01 06:00:12 2014
Sweep : completed
Sweep : completed
Sweep : 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: , [], [], [], [], [], [], [], [], [], [], []
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=, requested by (instance=1, osid=2993 (J001)), summary=.
Sat Mar 01 06:01:12 2014
Sweep : 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
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: , [], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 55297 (ORA 600 ) ========
*** 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=>报错 可能是 SYS_AUTO_SQL_TUNING_TASK 在分析SQL的时候发现 某些SQL的sqlText 过长或者特殊 ，导致 SYS_AUTO_SQL_TUNING_TASK 出现ORA-600
你可以禁用SYS_AUTO_SQL_TUNING_TASK 或者考虑：
打11203最新的PSU
页:
[1]