0.00000000 0x00000002 0x00000000 1399886134
0x15 9 0x00 0x014b 0x0016 0x0000.00151002 0x018000bf 0x0000.000.00000000 0x00000003 0x00000000 1399886134
0x16 9 0x00 0x014b 0x0017 0x0000.0015108e 0x018000b2 0x0000.000.00000000 0x00000003 0x00000000 1399886134
0x17 9 0x00 0x014b 0x0018 0x0000.00151095 0x018000b2 0x0000.000.00000000 0x00000001 0x00000000 1399886134
0x18 9 0x00 0x014b 0x0019 0x0000.001510a1 0x018000b4 0x0000.000.00000000 0x00000003 0x00000000 1399886134
0x19 9 0x00 0x014b 0x001a 0x0000.001510b9 0x018000b5 0x0000.000.00000000 0x00000002 0x00000000 1399886134
0x1a 9 0x00 0x014b 0x001b 0x0000.001510e7 0x018000b7 0x0000.000.00000000 0x00000003 0x00000000 1399886134
0x1b 9 0x00 0x014b 0x001c 0x0000.00151135 0x018000b9 0x0000.000.00000000 0x00000003 0x00000000 1399886134
0x1c 9 0x00 0x014b 0x001d 0x0000.0015113c 0x018000b9 0x0000.000.00000000 0x00000001 0x00000000 1399886134
0x1d 9 0x00 0x014b 0x001e 0x0000.00151146 0x018000bb 0x0000.000.00000000 0x00000003 0x00000000 1399886134
0x1e 9 0x00 0x014b 0x001f 0x0000.00151156 0x018000bc 0x0000.000.00000000 0x00000002 0x00000000 1399886134
0x1f 9 0x00 0x014b 0xffff 0x0000.00151165 0x018000be 0x0000.000.00000000 0x00000003 0x00000000 1399886134
0x20 9 0x00 0x014a 0x0021 0x0000.00150d73 0x018000bb 0x0000.000.00000000 0x00000001 0x00000000 1399886134
0x21 9 0x00 0x014a 0x0000 0x0000.00150d8b 0x018000bd 0x0000.000.00000000 0x00000003 0x00000000 1399886134
undo block trace文件:
UNDO BLK:
xid: 0x0016.01f.00000141 seq: 0x76c cnt: 0x2 irb: 0x2 icl: 0x0 flg: 0x0000
Rec
Offset Rec
Offset Rec
Offset Rec
Offset Rec
Offset
---------------------------------------------------------------------------
0x01 0x1ba0 0x02 0x17bc
*-----------------------------
* Rec #0x1 slt: 0x1f objn: 73429(0x00011ed5) objd: 73429 tblspc: 4(0x00000004)
* Layer: 11 (
Row) opc: 1 rci 0x00
Undo
type: Regular undo
Last buffer split:
No
Temp
Object:
No
Tablespace Undo:
No
rdba: 0x018000b3
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat
bit: 4 (post-11) padding: 1
op:
C uba: 0x018000b3.076c.07
Array
Update
of 20
rows:
tabn: 0 slot: 60(0x3c) flag: 0x2c
lock: 0 ckix: 157
ncol: 2 nnew: 1
size: 0
KDO Op code: 21
row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010002ab hdba: 0x010002aa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [12] 44 44 44 44 44 44 44 44 44 44 44 44
tabn: 0 slot: 61(0x3d) flag: 0x2c
lock: 0 ckix: 157
ncol: 2 nnew: 1
size: 0
KDO Op code: 21
row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010002ab hdba: 0x010002aa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
.................省略这一undo record中的一部分
col 1: [12] 44 44 44 44 44 44 44 44 44 44 44 44
tabn: 0 slot: 79(0x4f) flag: 0x2c
lock: 0 ckix: 157
ncol: 2 nnew: 1
size: 0
KDO Op code: 21
row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010002ab hdba: 0x010002aa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [12] 44 44 44 44 44 44 44 44 44 44 44 44
*-----------------------------
* Rec #0x2 slt: 0x1f objn: 73429(0x00011ed5) objd: 73429 tblspc: 4(0x00000004)
* Layer: 11 (
Row) opc: 1 rci 0x01
Undo
type: Regular undo
Last buffer split:
No
Temp
Object:
No
Tablespace Undo:
No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat
bit: 4 (post-11) padding: 1
op:
C uba: 0x018000b4.076c.01
Ar |