ORA-600 [ktspNextL1:4]错误解析
ORA-600 错误解析Alert Log的相关内容如下
Fri Aug 12 22:04:50 2011
Errors in file /db143/app/oracle/admin/orcl/bdump/orcl2_j002_794866.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1500
ORA-06512: at "SYS.DBMS_SPACE", line 1566
], [], [], [], [], [], [], []
Fri Aug 12 22:04:50 2011
对应的trace文件内容如下
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
ORACLE_HOME = /db143/app/oracle/product/10.2.0/db
System name: AIX
Node name: orcldb02
Release: 3
Version: 5
Machine: 00C80CB64C00
Instance name: orcl2
Redo thread mounted by this instance: 2
Oracle process number: 45
Unix process pid: 794866, image: oracle@orcldb02 (J002)
*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2011-08-12 22:04:47.935
*** MODULE NAME:(DBMS_SCHEDULER) 2011-08-12 22:04:47.935
*** SERVICE NAME:(SYS$USERS) 2011-08-12 22:04:47.935
*** SESSION ID:(1061.43911) 2011-08-12 22:04:47.935
*** 2011-08-12 22:04:47.935
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Current SQL statement for this session:
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
问题分析
这和oracle的bug 5649098的描述完全一致。请参考 Note ID 841158.1
导致该异常是因为scheduler job中的AUTO_SPACE_ADVISOR_JOB引起的
解决办法如下：
1. Ignore the error.
2. Upgrade to 11.1.0.7.
3. Rerun the job.
页:
[1]