? 0x00000001? 0x00000000? 1448954328
? ? 0x1d? ? 9? ? 0x00? 0x00ae? 0x002f? 0x0001.00000384? 0x00800155? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x1e? ? 9? ? 0x00? 0x00af? 0x001c? 0x0001.000003c8? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x1f? ? 9? ? 0x00? 0x00aa? 0x0002? 0x0000.028f649e? 0x00800156? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448952168
? ? 0x20? ? 9? ? 0x00? 0x00ae? 0x0004? 0x0001.00000a28? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448957928
? ? 0x21? ? 9? ? 0x00? 0x00af? 0x002a? 0x0001.00000dad? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448960328
? ? 0x22? ? 9? ? 0x00? 0x00ad? 0x0028? 0x0000.028f6482? 0x00800156? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448952168
? ? 0x23? ? 9? ? 0x00? 0x00ae? 0x000b? 0x0001.00000083? 0x00000000? 0x0000.000.00000000? 0x00000000? 0x00000000? 1448953127
? ? 0x24? ? 9? ? 0x00? 0x00af? 0x001a? 0x0001.00000427? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x25? ? 9? ? 0x00? 0x00ae? 0x0007? 0x0001.00000306? 0x00800157? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x26? ? 9? ? 0x00? 0x00ae? 0x0025? 0x0001.00000304? 0x00800157? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x27? ? 9? ? 0x00? 0x00af? 0x0010? 0x0001.00000a56? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448957928
? ? 0x28? ? 9? ? 0x00? 0x00ae? 0x001f? 0x0000.028f6492? 0x00800156? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448952168
? ? 0x29? ? 9? ? 0x00? 0x00ae? 0x0009? 0x0001.00000335? 0x00800155? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x2a? ? 9? ? 0x00? 0x00af? 0xffff? 0x0001.00000e73? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448960452
? ? 0x2b? ? 9? ? 0x00? 0x00ae? 0x0006? 0x0001.00000401? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x2c? ? 9? ? 0x00? 0x00ae? 0x0015? 0x0001.000002d2? 0x00800157? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x2d? ? 9? ? 0x00? 0x00ae? 0x0022? 0x0000.028f6466? 0x00800156? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448952168
? ? 0x2e? ? 9? ? 0x00? 0x00af? 0x001b? 0x0001.000003e4? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
? ? 0x2f? ? 9? ? 0x00? 0x00ae? 0x0014? 0x0001.000003a2? 0x00800158? 0x0000.000.00000000? 0x00000001? 0x00000000? 1448954328
?End dump data blocks tsn: 1 file#: 2 minblk 105 maxblk 105
?[ora10g@seconary udump]$
可见undo segment header block在几个结构皆有scn,到底是哪个scn呢
?要解决这个问题，就要去理解undo segment header block的原理及结构了
?转换思路，我们看看trc文件有什么信息，或者说我们重要要关注哪些部分的信息
---仅列出最重要的信息
Unix process pid: 27479, image: oracle@seconary (SMON)? ---可见是smon进程在工作时报了ora-600 2662错误，从这儿也可以看出SMON进程是负责数据库一致性，进行实例恢复和数据一致性校验工作的
*** SERVICE NAME:(SYS$BACKGROUND) 2015-12-01 01:18:30.725
?*** SESSION ID:(164.1) 2015-12-01 01:18:30.725
?*** 2015-12-01 01:18:30.725
?ksedmp: internal or fatal error
?ORA-00600: internal error code, arguments: [2662], [0], [91], [0], [333574], [8388713], [], []? --ORA-600具体报错
----引发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 ---