ORA-00600: internal error code, arguments: [qkssao2s1], [], [], [], [], [], [...
数据库版本：10.2.0.1操作系统：linux 5.4 x64
alert日志报错
Wed Mar 26 22:05:12 2014
Errors in file /opt/app/oracle/admin/orcl/bdump/orcl_j001_6935.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Wed Mar 26 22:05:18 2014
Errors in file /opt/app/oracle/admin/orcl/bdump/orcl_j001_6935.trc:
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 18963
], [], [], [], [], [], [], []
trace文件内容
$ more /opt/app/oracle/admin/orcl/bdump/orcl_j001_6935.trc
/opt/app/oracle/admin/orcl/bdump/orcl_j001_6935.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1
System name: Linux
Node name: chinagps.dba
Release: 2.6.18-164.el5
Version: #1 SMP Thu Sep 3 03:28:30 EDT 2009
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 81
Unix process pid: 6935, image: oracle@chinagps.dba (J001)
*** ACTION NAME:(GATHER_STATS_JOB) 2014-03-26 22:05:12.201
*** MODULE NAME:(DBMS_SCHEDULER) 2014-03-26 22:05:12.201
*** SERVICE NAME:(SYS$USERS) 2014-03-26 22:05:12.201
*** SESSION ID:(406.49956) 2014-03-26 22:05:12.201
*** 2014-03-26 22:05:12.201
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], []
Current SQL statement for this session:
select /*+ no_parallel_index(t,IND_ALARM_LOG_NULL) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitorin
g no_expand index_ffs(t,"IND_ALARM_LOG_NULL") */ count(*) as nrw,count(distinct sys_op_lbid(144044,'L',t.rowid)) as nlb,count(distinct
hextoraw(sys_op_descend("CLEAR_TIME")||sys_op_descend(0))) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "GPSOLD"."ALAR
M_LOG" sample block (5.3430232558,1)t where "CLEAR_TIME" is not null or 0 is not null
----- PL/SQL Call Stack -----
object lineobject
handle numbername
0x2dd6353c0 9406package body SYS.DBMS_STATS
0x2dd6353c0 9919package body SYS.DBMS_STATS
0x2dd6353c0 10541package body SYS.DBMS_STATS
0x2dd6353c0 13027package body SYS.DBMS_STATS
0x2dd6353c0 18889package body SYS.DBMS_STATS
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
000000000 ? 000000000 ?
000000000 ? 000000001 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
000000000 ? 000000000 ?
000000000 ? 000000001 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
000000000 ? 000000000 ?
000000000 ? 000000001 ?
kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ?
000000000 ? 000000000 ?
000000000 ? 000000001 ?
kgeasnmierr()+163 call kgerinv() 006579D40 ? 2AABEDB40040 ?
000000000 ? 000000000 ?
000000001 ? 000000001 ?
qkssaOptdef2Struct(call kgeasnmierr() 006579D40 ? 2AABEDB40040 ?
)+969 000000000 ? 000000000 ?
000000056 ? 000000000 ?
qkssaSamplePushdowncall qkssaOptdef2Struct(2AABEE486480 ? 2AABEE481078 ?
()+247 ) 000000000 ? 000000000 ?
000000056 ? 000000000 ?
qkaMarkQkn()+2528 call qkssaSamplePushdown2AABEE47A310 ? 000000001 ?
() 000000000 ? 000000000 ?
000000056 ? 000000000 ?
qkaMarkQkn()+416 call qkaMarkQkn() 2AABEE481078 ? 2AABEE47A1A8 ?
000000004 ? 000000000 ?
000000056 ? 000000000 ?
qkadrv2Pre()+93 call qkaMarkQkn() 000000000 ? 000000000 ?
000000001 ? 000000000 ?
000000056 ? 000000000 ?
qkadrv2()+23 call qkadrv2Pre() 28C1D2D20 ? 000000000 ?
000000001 ? 000000000 ?
000000056 ? 000000000 ?
opitca()+1824 call qkadrv2() 28C1D2D20 ? 000000000 ?
000000001 ? 000000000 ?
000000056 ? 000000000 ?
kksFullTypeCheck()+call opitca() 2AABEED300C0 ? 28C1D2D20 ?
30 000000001 ? 000000000 ?
000000056 ? 000000000 ?
rpiswu2()+420 call kksFullTypeCheck() 7FFF545BA4B0 ? 28C1D2D20 ?
000000001 ? 000000000 ?
000000056 ? 000000000 ?
kksLoadChild()+5172call rpiswu2() 2DC51ABE8 ? 000000000 ?
2D3ECEE7C ? 000000022 ?
2D3ECEC10 ? 200000000 ?
kkslod()+135 call kksLoadChild() 006579D40 ? 2AAD75138 ?
7FFF545BC2A8 ? 7FFF545BC218 ?
3243151800000000 ?
200000000 ?
kglobld()+984 call kkslod() 006579D40 ? 2AAD75138 ?
7FFF545BC2A8 ? 7FFF545BC218 ?
3243151800000000 ?
200000000 ?
kglobpn()+1472 call kglobld() 006579D40 ? 2982FA920 ?
7FFF545BC2A8 ? 29DA018F0 ?
000000000 ? 005192580 ?
kglpim()+304 call kglobpn() 006579D40 ? 29DA018F0 ?
7FFF545BC2A8 ? 000000001 ?
005192580 ? 2AAD75138 ?
kglpin()+1330 call kglpim() 006579D40 ? 7FFF545BC2A8 ?
29DA018F0 ? 2AAD75138 ?
005192580 ? 2AAD75138 ?
kxsGetRuntimeLock()call kglpin() 006579D40 ? 7FFF545BC2A8 ?
+266 2A75A2B00 ? 2AAD75138 ?
300000003 ? 900000003 ?
kksfbc()+15871 call kxsGetRuntimeLock()006579D40 ? 2AABEED300C0 ?
7FFF545BC2A8 ? 2AAD75138 ?
300000003 ? 900000003 ?
kkspsc0()+1862 call kksfbc() 2AABEED300C0 ? 000000003 ?
000000108 ? 2AABEDB91E70 ?
0000001EC ? 000000000 ?
kksParseCursor()+14call kkspsc0() 2AABEDB517E0 ? 2AABEDB91E70 ?
2 0000001EC ? 000000003 ?
222200000006 ? 000002222 ?
opiosq0()+1678 call kksParseCursor() 7FFF545BCCE8 ? 2AABEDB91E70 ?
0000001EC ? 000000003 ?
222200000006 ? 000002222 ?
opipls()+11283 call opiosq0() 000000003 ? 00000000E ?
7FFF545BD108 ? 000002222 ?
222200000006 ? 000002222 ?
opiodr()+972 call opipls() 000000066 ? 000000006 ?
7FFF545BEB40 ? 000000000 ?
000000000 ?
DC51ABE800000000 ?
rpidrus()+198 call opiodr() 000000066 ? 000000006 ?
7FFF545BEB40 ? 000000003 ?
0054106F0 ?
DC51ABE800000000 ?
skgmstack()+158 call rpidrus() 7FFF545BE188 ? 000000006 ?
7FFF545BEB40 ? 000000003 ?
0054106F0 ?
DC51ABE800000000 ?
rpidru()+116 call skgmstack() 7FFF545BE160 ? 006579920 ?
00000F618 ? 0007539A8 ?
7FFF545BE188 ?
DC51ABE800000000 ?
rpiswu2()+420 call rpidru() 7FFF545BE820 ? 006579920 ?
00000F618 ? 0007539A8 ?
7FFF545BE188 ?
DC51ABE800000000 ?
rpidrv()+1519 call rpiswu2() 2DC51ABE8 ? 000000000 ?
2DC51AC24 ? 000000022 ?
2AABEDB4BA28 ? 424900000000 ?
psddr0()+441 call rpidrv() 000000003 ? 000000066 ?
7FFF545BEB40 ? 000000039 ?
2AABEDB4BA28 ? 424900000000 ?
psdnal()+342 call psddr0() 000000003 ? 000000066 ?
7FFF545BEB40 ? 000000031 ?
2AABEDB4BA28 ? 424900000000 ?
pevm_EXIM()+216 call psdnal() 2AABEDB7C2C8 ? 000000000 ?
7FFF545BEB40 ? 2AABEDFFB640 ?
2DD6353C0 ? 424900000000 ?
pfrinstr_EXIM()+53 call pevm_EXIM() 2AABEDB7C4A0 ? 000000000 ?
7FFF545BEB40 ? 2AABEDFFB640 ?
2DD6353C0 ? 424900000000 ?
pfrrun_no_tool()+65call pfrinstr_EXIM() 2AABEDB7C4A0 ? 295C0C494 ?
2AABEDB7C508 ? 2AABEDFFB640 ?
2DD6353C0 ? 424900000000 ?
pfrrun()+906 call pfrrun_no_tool() 2AABEDB7C4A0 ? 295C0C494 ?
2AABEDB7C508 ? 2AABEDFFB640 ?
2DD6353C0 ? 424900000000 ?
plsql_run()+841 call pfrrun() 2AABEDB7C4A0 ? 000000000 ?
2AABEDB7C508 ? 2AABEDB7C2C8 ?
2DD6353C0 ? 293F8323E ?
peidxr_run()+245 call plsql_run() 2AABEDB7C4A0 ? 000000061 ?
2AABEDB7C218 ? 2AABEDB7C2C8 ?
2DD6353C0 ? 000000000 ?
peidxexe()+89 call peidxr_run() 2AABEDB7C250 ? 000000061 ?
2AABEDB7C218 ? 2AABEDB7C4A0 ?
2DD6353C0 ? 000000000 ?
kkxdexe()+296 call peidxexe() 2AABEDB7C250 ? 000000061 ?
2AABEDB7C218 ? 2AABEDB7C4A0 ?
2DD6353C0 ? 000000000 ?
kkxmpexe()+232 call kkxdexe() 2AABEDB7C250 ? 2AABEDF57E28 ?
2AABEDF5A800 ? 2AABEDB7C4A0 ?
000000000 ? 000000000 ?
kgmexwi()+564 call kkxmpexe() 006579D40 ? 2CC572D60 ?
2AABEDF5F568 ? 2AABEDB7C250 ?
2DD6353C0 ? 2AABEDF5A800 ?
kgmexec()+1278 call kgmexwi() 006579D40 ? 000000001 ?
7FFF545C0010 ? 2CC572D60 ?
2AABEDF5F568 ? 2AABEDF5FA90 ?
evapls()+686 call kgmexec() 006579D40 ? 000000001 ?
7FFF545C0010 ? 29957D6D0 ?
294118D00 ? 2AABEDF5A980 ?
evaopn2()+415 call evapls() 296FE5D60 ? 000000000 ?
2AABEDFB81F0 ? 006579D40 ?
296FE5CF8 ? 2AABEDF5A980 ?
kkxmexcs()+139 call evaopn2() 2AABEDFB81F0 ? 2AABEDF66158 ?
296FE5D60 ? 006579D40 ?
2AABEDF5AAC0 ? 2AABEDF5A980 ?
opiexe()+15599 call kkxmexcs() 2AABEDFB81F0 ? 2AABEDF66158 ?
296FE5D60 ? 296FE5D60 ?
296FE5C60 ? 000000000 ?
kpoal8()+2133 call opiexe() 000000049 ? 000000003 ?
7FFF545C1390 ? 000000001 ?
296FE5C60 ? 000000000 ?
opiodr()+972 call kpoal8() 00000005E ? 000000000 ?
7FFF545C4978 ? 000000001 ?
000000001 ? 000000000 ?
kpoodr()+597 call opiodr() 00000005E ? 000000000 ?
7FFF545C4978 ? 000000000 ?
0054105B0 ? 000000000 ?
upirtrc()+2060 call kpoodr() 2AABEDB6ADA0 ? 00000005E ?
7FFF545C4978 ? 000000000 ?
0054105B0 ? 000000000 ?
kpurcsc()+125 call upirtrc() 2AABEDB6ADA0 ? 00000005E ?
7FFF545C4978 ? 7FFF545C4AE0 ?
7FFF545C5A50 ? 0038FD18E ?
kpuexecv8()+1767 call kpurcsc() 7FFF545C6250 ? 00000005E ?
7FFF545C4978 ? 7FFF545C4AE0 ?
7FFF545C5A50 ? 0038FD18E ?
kpuexec()+2595 call kpuexecv8() 2AABEDB6DD08 ? 2AABEDB60508 ?
2AABEDB60588 ? 000000000 ?
2AAB00000000 ? 7FFF545C7334 ?
OCIStmtExecute()+41call kpuexec() 000000001 ? 2AABEDB60508 ?
2AABEDB6AD30 ? 000000001 ?
2AAB00000000 ? 000000000 ?
jslvec_execcb1()+15call OCIStmtExecute() 000000001 ? 2AABEDB60508 ?
74 2AABEDB6AD30 ? 000000001 ?
2AAB00000000 ? 000000000 ?
jslvswu()+58 call jslvec_execcb1() 7FFF545C9EB8 ? 2AABEDB60508 ?
2D30F3FA8 ? 000000000 ?
000000000 ? 2DD8B45B8 ?
jslve_execute0()+20call jslvswu() 000000000 ? 001C5AE70 ?
90 7FFF545C9EB8 ? 000000000 ?
000000000 ? 2DD8B45B8 ?
Cannot find symbol
Cannot find symbol
Cannot find symbol
jslve_execute()+278call jslve_execute0() 7FFF545CB5E8 ? 0000022B6 ?
000000002 ? 7FFF545CB5D0 ?
000000000 ? 000000000 ?
rpiswu2()+420 call jslve_execute() 7FFF545CB4D8 ? 000000002 ?
7FFF545CB5E8 ? 0000022B6 ?
7FFF545CB5D0 ? 000000000 ?
kkjex1e()+367 call rpiswu2() 2DC51ABE8 ? 000000000 ?
7FFF545CB4B4 ? 000000002 ?
7FFF545CB528 ? 800000000 ?
kkjsexe()+343 call kkjex1e() 7FFF545CB5E8 ? 0000022B6 ?
000000002 ? 7FFF545CB5D0 ?
2DDE19038 ?
545C000000000000 ?
kkjrdp()+892 call kkjsexe() 7FFF545CB5E8 ? 0000022B6 ?
000000002 ? 000000002 ?
2DDE19038 ?
545C000000000000 ?
opirip()+1060 call kkjrdp() 7FFF545CB5E8 ? 0000022B6 ?
000000002 ? 000000002 ?
2DDE19038 ?
545C000000000000 ?
opidrv()+582 call opirip() 000000032 ? 000000004 ?
7FFF545CCCD8 ? 000000002 ?
2DDE19038 ?
545C000000000000 ?
sou2o()+114 call opidrv() 000000032 ? 000000004 ?
7FFF545CCCD8 ? 000000002 ?
2DDE19038 ?
545C000000000000 ?
opimai_real()+317 call sou2o() 7FFF545CCCB0 ? 000000032 ?
000000004 ? 7FFF545CCCD8 ?
2DDE19038 ?
545C000000000000 ?
main()+116 call opimai_real() 000000003 ? 7FFF545CCD40 ?
000000004 ? 7FFF545CCCD8 ?
2DDE19038 ?
545C000000000000 ?
<0x3d4401d994> call main() 000000003 ? 7FFF545CCD40 ?
000000004 ? 7FFF545CCCD8 ?
2DDE19038 ?
545C000000000000 ?
--------------------- Binary Stack Dump ---------------------
分析IND_ALARM_LOG_NULL index 信息
SQL> SELECT DBMS_METADATA.GET_DDL('INDEX','IND_ALARM_LOG_NULL','GPSOLD') FROM DUAL;
CREATE INDEX "GPSOLD"."IND_ALARM_LOG_NULL" ON "GPSOLD"."ALARM_LOG" ("CLEAR_TIM
E", 0)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "INFO"
APPLIES TO:
Oracle Server - Enterprise Edition - Version: 10.2.0.1.0
This problem can occur on any platform.
SYMPTOMS
ORA-600 is signalled when running DBMS_STATS.
With the stack trace:
qkssaOptdef2Struct <- qkssaSamplePushdown <- qkaMarkQkn <- qkaMarkQkn <- qkadrv2Pre <- qkadrv2 <- opitca
CAUSE
The underlying reason is unpublished bug 5005939 ' ORA-600 DURING DBMS_SQLTUNE'.
This causes ORA-600 when running a query against a table with a functional index which contains a constant, such as:
create index ix1 on call_table(call_no, 1);
SOLUTION
This problem can be worked around by gathering the statistics first and then creating the index:
SQL>exec dbms_stats.gather_table_stats('SCOTT', 'CALL_TABLE');
SQL>create index ix1 on call_table(callno, 1);
At the time of writing, a decision had not yet been made on a final solution for the issue.
页:
[1]