----引发ORA-600报错的SQL
Current SQL statement for this session:
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
--报错时产生的调用波函数堆栈,用这个去MOS进行匹配,可以确认是否是BUG或获取相关MOS文章,进行进一步分析
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ssd_unwind_bp: unhandled instruction at 0x76b061 instr=f
ssd_unwind_bp: unhandled instruction at 0x1127327 instr=f
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFF208BF9F0 ? 7FFF208BFA50 ?
7FFF208BF990 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFF208BF9F0 ? 7FFF208BFA50 ?
7FFF208BF990 ? 000000000 ?
中间略
+244 000000004 ? 7FFF208CF558 ?
000000000 ? 7FFF00000000 ?
_start()+41 call __libc_start_main() 00072D108 ? 000000001 ?
7FFF208CF718 ? 000000000 ?
000000000 ? 000000003 ?
我们从报错的SQL进行分析