redo trace文件的解析

来源：互联网发布：淘宝网络推广策划案编辑：程序博客网时间：2024/04/28 00:26

redo的trace简单解析:

op: L itl: xid: 0x0002.011.0002b5e1 uba: 0x00c00098.3eef.04
flg: C--- lkc: 0 scn: 0x0000.41dcce8f
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0049b7d7 hdba: 0x00400978
itli: 2 ispac: 0 maxfr: 4863
tabn: 0 slot: 41(0x29)
CHANGE #3 TYP:2 CLS:1 AFN:1 DBA:0x0049b7d7 OBJ:86887 SCN:0x0000.41dcce94 SEQ:1 OP:11.2 ENC:0 RBL:0
KTB Redo
op: 0x01 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: F xid: 0x0008.008.00031046 uba: 0x00c28bc9.405e.06 xid: 0x0008.008.00031046 表示这个交易的事物号是 0x0008.008.00031046
KDO Op code: IRP row dependencies Disabled Op code: IRP row 表示这个是一条插入
xtype: XA flags: 0x00000000 bdba: 0x0049b7d7 hdba: 0x00400978
itli: 2 ispac: 0 maxfr: 4863 bdba: 0x0049b7d7 bdba: 0x0049b7d7 表示这个更新数据的dba号是0x0049b7d7
tabn: 0 slot: 41(0x29) size/delt: 123 slot: 41(0x29)表示这个交易在他所在存储的块中的第41+1个槽位上
fb: --H-FL-- lb: 0x2 cc: 39 fb: --H-FL-- 表示这个交易有头有尾是个完整的交易 ----------------- cc: 39 表示这个表有39列
null:
01234567890123456789012345678901234567890123456789012345678901234567890123456789
---N-----NNNNNNNNNNNNNNN-NNN-N-NN--NNN-
col 0: [ 5] c4 15 09 61 13
col 1: [ 2] c1 04
col 2: [ 3] c2 03 54
col 3: *NULL*
col 4: [ 6] 53 4f 55 52 43 45
col 5: [20] 57 4f 52 4b 47 52 4f 55 50 5c 54 49 4e 4b 50 41 44 2d 50 43
col 6: [10] 54 49 4e 4b 50 41 44 2d 50 43
col 7: [ 2] c1 32
col 8: [ 1] 80
col 9: *NULL*
col 10: *NULL*
col 11: *NULL*
col 12: *NULL*
col 13: *NULL*
col 14: *NULL*
col 15: *NULL*
col 16: *NULL*
col 17: *NULL*
col 18: *NULL*
col 19: *NULL*
col 20: *NULL*
col 21: *NULL*
col 22: *NULL*
col 23: *NULL*
col 24: [ 7] 74 69 6e 6b 70 61 64
col 25: *NULL*
col 26: *NULL*
col 27: *NULL*
col 28: [ 2] c1 04
col 29: *NULL*
col 30: [11] 78 75 01 0f 07 0d 29 06 e5 1f 18
col 31: *NULL*
col 32: *NULL*
col 33: [ 1] 80
col 34: [ 5] 32 37 36 34 31
col 35: *NULL*
col 36: *NULL*
col 37: *NULL*

col 38: [ 6] c5 0f 1d 63 61 21

其中colxx 表示各列的dump数据值

0 0