涉及版本
Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 17-Nov-2011***
Symptoms
We get the errors below in alert.log:
ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []
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], [], [], [], [], [], [], []
From the trace file, we see that the failing statement was an INSERT operation:
此会话和下面的sql相关：
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'))
在trace文件中，在PL/SQL 栈调用部分显示如下部分：
----- PL/SQL Call Stack -----
0xa7b85db8 1834 package body SYS.DBMS_SPACE
0xa82a0BB8 344 SYS.RI$_ADV_OBJSPACE_TREND_T
0xa82a0BB8 1485 SYS.RI$_ADV_OBJSPACE_TREND_T
0xa79b07c8 1535 package body SYS.PRVT_ADVISOR
可以看到如下过程：
ktspGetNextL1ForSca <- ktspGenExtentMap1 <- kteinmap1 <- kteinmap <- kdglfp <- kdgbp <- kdg_block_auto <- ktsa_object_space_u <- sage <- ktsaps_object_space <- usage <- pevm_icd_call_commo
原因：
Unpublished bug 6746222 ORA-00600 [KTSPNEXTL1:4] DURING WORKLOAD
Closed as a potential duplicate of unpublished Bug 5649098
Unpublished bug 5649098 ORA 600 [KTSPNEXTL1:4] WHILE SEGMENT SHRINK
Closed as not reproducible in 11.1.0.7, but a fix was never identified
为了解决此问题，可以使用如下步骤：
1. Ignore the error.
2. Upgrade to 11.1.0.7.
3. Rerun the job.
这是一个为发布的bug，并且在11.1.0.7版本中修复。
Reports of the same problem exist in 10.2 and those have been either suspended (because the problem only happened once) or marked as potential duplicate of unpublished bug 5649098.
This error happens when the advisor job runs continuously concurrent with other heavy segment operations. This bug does not cause any data corruption or instance crash. The workaround is to run the job again.